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: 
sanjujeeboy
Creator
Creator

How to build this logic

 

sanjujeeboy_0-1591193143498.png

 

i want to achieve the Actual spend as 3000. Logic: Whenever Target>actual it should show spend for that category 

so for Laptop target>actual so only laptop spend should appear in Actual spend.

Currently what is happening is when i click on Accessories its adding the targets of both mobile and laptop and actuals of mobile and laptop. so combining both together target is becoming greater than actual and im getting Actual spend as 4000.

 

Labels (2)
0 Replies