Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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