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