Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am trying to create a qliksense sheet and it got a filter pane which takes value from one of the column in a dimension table.
I am trying to write an expression which only shows certain values in the filter pane from that column
For example
Column
A
B
C
D
In the filter pane I only wanted to show A and B
Which expression will be helpful to achieve this.
Thanks
Hi,
May be as in attached file
Andrey
Hi,
Yeah you can try with Andrey suggestion
Calculated dimension:
"=if(Column='A' or Column='B',Column) "
Also you can you do it below way.
=pick(Match(Column,'A','B'),'A','B')
Thanks, Deva