topic Re: Only show dimensions with a variance in QlikView

Only show dimensions with a variance

hjm35055 — Fri, 26 Jan 2018 20:26:08 GMT

Hi,

I have data that looks like below in a pivot table. I am trying to only display the Entitys that have a variance. I tried creating a calculated dimension but it is not working. It was =If(Revenue-Alt. Revenue<>0,[Entity ID]). I have a feeling it's because of the pivot table but if possible, I would like to keep it in a pivot table.

Any ideas on how I can do this?

Thank you,

Hannah

Re: Only show dimensions with a variance

Nicole-Smith — Fri, 26 Jan 2018 21:53:25 GMT

Why not use a calculation like this instead of trying to subtract?

if([Revenue] <> [Alt. Revenue], [Entity ID])

Re: Only show dimensions with a variance

hjm35055 — Thu, 01 Feb 2018 12:11:03 GMT

Thanks Nicole, this did not work either. What I ended up doing was altering the expression to allow Qlik to naturally remove the 0 variance instead of altering the Entity ID dimension.

Revenue: IF(FABS(Sum(Revenue) - Sum([Alt. Revene])) = 0, 0, Sum(Revenue))

Alt. Revenue: IF(FABS(Sum(Revenue) - Sum([Alt. Revene])) = 0, 0, Sum([Alt. Revenue]))