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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

when i use If loop (with a variable button selection ) in table chart , it is not filtering out correctly

when i use If loop (with a variable button selection ) in table chart , it is not filtering out correctly

 

Example: 

IF(vselectsheet = 0, Sum({<[Division Name]={'C'}>}[Total]),

2 Replies
Zapparoli
Creator II
Creator II

Hi User09,

In this case you need to ask Qlik to evaluate the variable using:

$(vselectsheet

So:

IF($(vselectsheet) = 0, Sum({<[Division Name]={'C'}>}[Total]),

-Matheus

 

Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics

Qlikuser09
Creator II
Creator II
Author

i have another column with the Division name , i want the table to show only the Division name 'C', with the $(vselectsheet) = 0 and so on . , but with this code IF($(vselectsheet) = 0, Sum({<[Division Name]={'C'}>}[Total]) , for the division name C , i am getting the Total , but for others divisions the table chart is displaying"-"