Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I use a variable created from a table that isn't linked?

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.

1 Solution

Accepted Solutions
hector_munoz
Specialist
Specialist

Hi Nicholas,

Yes, you can. I attach you a sample. Hope it serves!

Regards,

H

View solution in original post

2 Replies
hector_munoz
Specialist
Specialist

Hi Nicholas,

Yes, you can. I attach you a sample. Hope it serves!

Regards,

H

Not applicable
Author

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,