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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
krmvacar
Creator II
Creator II

variable in Sum

Hi All,

I have a variable and I have 2 total values in this variable.

the content of my variable Test2; sum(grosstotal) + sum (grossamount)

My expression =  Sum({<PERNUM = {"=Sum([$(vTest2)]) > 0"}>} $(vTest2)) but is not working.

What I want to do here is to bring the data of the personnel except the zero sum.

how can i use the variable here please help

Labels (2)
10 Replies
krmvacar
Creator II
Creator II
Author

hi @Digvijay_Singh  

Thank you very much for your help i will keep trying 🙂