Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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