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: 
Anonymous
Not applicable

Error Syntax...

Dear Experts,

I am writing this expression:

=if((sum([Pre-Tax Value])/VTotalPreTaxValues)>'02.00%', CustomerName)

I have to display only those Customer whose % value is greater than 2.00%, I am using above expression but it is not giving any customer name...

Please suggest....

Regards,

Balraj

1 Reply
maleksafa
Specialist
Specialist

in your expression you are comparing the value of sum(pretax)/vtotal... with the string '02.00%' and i don't think they are saved like that in your schema right? the 2.00% is probably a number formatting in the chart that you are using, so check first what does this expression returns sum([Pre-Tax Value])/VTotalPreTaxValues) and then add the filter.

maybe it should be sum([Pre-Tax Value])/VTotalPreTaxValues) > 0.2