Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Reading list selection into Variables for Dynamic Calculations

Hello,

I am hoping to get some suggestions of my use case.

I have a list of multiple products with a license count. I want do a calculation based on a Node. Each product could have different rules and and 8 nodes to pick from.

I think the solution would be using and If statement with Variables.

Node 1-4 have a calcuation to mutiple the license count by 2 for every node.

Example Product 1 and Node1 = (License count x Node 1 Calc)

               Product 1 and Node 2 = (License count x Node 1 Calc)*2

               Product 1 and Node 3 = (License count x Node 1 Calc)*4

               Product 1 and Node 4 = (License count x Node 1 Calc)*8

Node 5-9

     Product 2 and Node 5 = (License count x Node 5 Calc)

Product 2 and Node 6 = (License count x Node 5 Calc)*2

Product 2 and Node 7 = (License count x Node 5 Calc)*4

Product 2 and Node 8 = (License count x Node 5 Calc)*8

I would like the selections for the product and node to be variables that are picked up from a user input or feild value.

For example I would like them to be able to pick the product and the current node and somehow save that. So that I can calculate the license differance if they move to a new node and product.

Any help on this solution would be greatly appreciated.

Thank you,

Labels (1)
0 Replies