Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, fairly new to Qlikview and I'm working on building a dashboard around Spend. I have 3 types of spend loaded into 3 tables, 2 of which are linked with the last table standing on it's own without a link. If I create a variable to total the spend from the 2 linked tables, can I use it in an expression with my 3rd unlinked table?
Lets say the variable looks like this:
Variable Name: vVariable, Value: Sum([SpendA]+[SpendB])
If I want to show a ratio of SpendC (unlinked table) to the total spend overall of Spend A+B and C, can I use a variable to calculate it? Something like the following? I keep getting an error saying there's no data to display.
([SpendC]/([SpendC]+$(vVariable)))*100
Any help would be appreciated.
Hi Nicholas,
Yes, you can. I attach you a sample. Hope it serves!
Regards,
H
Hi Nicholas,
Yes, you can. I attach you a sample. Hope it serves!
Regards,
H
Thank you very much, this resolved my issue. Turns out I was missing "=" in my variable and the expressions you provided was more simplified.
Regards,