Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Ravindran_Nadar
Contributor
Contributor

How to show table based on two field condition

Hi,


I have been working on qlikview to qlik sense migration, in qlikview I have used the condition like this =GetSelectedCount(global_year)<>0 and GetSelectedCount(global_month)<>0 to show the straight table only if user selects one year and one month.
Same I am doing in Qlik sense but it is not working, I have used so many expression find these below but nothing works.
Please help as my client wants that condition.

len(GetCurrentSelections(global_year))>0 and len(GetCurrentSelections(global_month))>0

//GetSelectedCount(global_year)>0 and GetSelectedCount(global_month)>0

 

for selecting one year condition i have used this expression(len(GetCurrentSelections(global_year))>0 )

and it is working properly but for two field it is not working please assist me ASAP.

 



Labels (1)
1 Reply
dwforest
Specialist II
Specialist II

GetSelectedCount(global_year)>0 and GetSelectedCount(global_month)>0

should work... if you put in a measure of a Text Object and select values in both fields it should display -1 (true)