Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Shreyannn
Contributor
Contributor

By Default Table has to show data but when ever i select filter it has to show Zero,

By Default Table has to show data but when ever i select filter it has to show Zero, I tried of using 

If(GetSelectedCount([Program Division])=0,

Its not working 

4 Replies
Kushal_Chawda

did you try below measure?

If(GetSelectedCount([Program Division])>0,0,YourExpression)

Shreyannn
Contributor
Contributor
Author

I previously used this, but default data is not showing. when ever i select the filter its showing data for other filters as well. 

Shreyannn
Contributor
Contributor
Author

 When ever i open the dashboard i want to see the data in table for all dimensions but if i select only Program division value it has to show null in the table.