Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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 II
Master II

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,...)