Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (2)
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)