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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
pallabi_jor
Contributor
Contributor

how to use variable in set analysis

Hi all,

variable= sum(Cost)/ sum( SellingPrice) //  -- result  is in percentage

I need to display the count of product whose percentage is equal to 5.5%

= count( {<$(=$(Variable))={'5.5'}>}Product)

I am writing above expression, but not getting  correct answer

Thanks

1 Reply
andrey_krylov
Specialist
Specialist

Hi. Try this

count( {< Product = {"=sum(Cost)/sum(SellingPrice)=0.055"}>} Product)