topic How to achieve this logic in QlikView

How to achieve this logic

sanjujeeboy — Sat, 16 Nov 2024 00:32:42 GMT

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.

@sunny_talwar @jagan

Re: How to achieve this logic

sunny_talwar — Thu, 04 Jun 2020 11:37:40 GMT

The information provided is not enough to know what you have (expressions, dimensions, logics etc) to answer your post. Are you able to provide a sample where we can see this?

Re: How to achieve this logic

sanjujeeboy — Sat, 06 Jun 2020 07:58:33 GMT

Hi Sunny,

I have attached the QVF file as well as the excel used. I have also described the requirement in the app.

Kindly look into this.

Thanks

@sunny_talwar

Re: How to achieve this logic

sunny_talwar — Mon, 08 Jun 2020 14:21:43 GMT

Change your expression for Actual Spend to

Sum(Aggr(if(sum({<plan={'Target'}>}values) - sum({<plan={'Actual'}>}values)>0, sum({<plan={'Spend'}>}values) ,0), Phase, Category, Accesory))

Re: How to achieve this logic

sanjujeeboy — Tue, 09 Jun 2020 05:12:44 GMT

Thanks Sunny!!! its working as required.