Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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)