Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]),
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
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"-"