Skip to main content
Question

How to filter view table based upon view variable

  • November 1, 2022
  • 4 replies
  • 64 views

Forum|alt.badge.img+5

Hy,

In analyses when we add a KPI in an OLAP, the OLAP automatically filters but in view tables I am seeing 0's with 1's, I want to exclude all the 0's and that too based on a view variable

 

Any help ?

4 replies

abhishek.chatu14
Level 11
Forum|alt.badge.img+4

The way you filter views using view variable is as follow

 

id: ${ (VARIABLE === 'EXPEXTED_VARIABLE_VALUE' && 'KM_FILTER_ID')}

 

Which is more like

 

IF VARIABLE === 'EXPEXTED_VARIABLE_VALUE' THEN 'KM_FILTER_ID' where ,KM_FILTER_ID' is the KPI ID

 

Please refer to the following link and look at Filtering with variables (input) that are strings section

https://docs.celonis.com/en/views-filters.html#UUID-ce16c4c4-f584-c2fc-4f59-52f0302f4be5_id_ViewsFilters-Filteringwithvariablesinputthatarestrings


Forum|alt.badge.img+7

Hi @Abhishek Chaturvedi !

 

Do you have some example to use view variable in filters?

 

Where this Id is define? In YAML KM or YAML Olap?

 

Thanks


abhishek.chatu14
Level 11
Forum|alt.badge.img+4

image


Forum|alt.badge.img+7

image

Thanks @Abhishek Chaturvedi