Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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"-"