Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

AdHoc Report - how to - when select a filter, automatically display another 2 more filters?

Hi guys, 

i am creating adhoc report. user is looking for - when i select a field in this dimension list, it will automaticllay display another 2 more dimensions in the pivot table. 

But i failed to do so, when i un-select the dimension, the other dimension to display in the pivot table, how should i script?

Sample scenario: i select on 'Exclusive' , it will automatically display the 'From To' date. 

But wheni unselect Exclusive, the From to date still there. 

jim_chan_1-1659698902355.png

My Expression:

jim_chan_2-1659699021280.png

My ShowColumn IF

jim_chan_3-1659699064073.png

=If(GetSelectedCount(%P_Dimension)='Exclusive',0,1)

So, my expected result is, the FromToDate dimension , ONLY display out WHEN i select the Exclusive. When i Un-select Exclusive, FromTo Date will not be displayed on the Pivot Table.

Please help!

 

Rgds

 

Jim

 

 

Labels (4)
1 Reply
edwin
Master
Master

getselectedcount returns the number of selected values - its result is numeric.  you cant compare it with a string.  maybe what you wanted is if( getselectedcount (...) =1,...)