topic Re: VARIABLE WITH DYNAMIC NAME in QlikView

VARIABLE WITH DYNAMIC NAME

souadouert — Thu, 13 Sep 2018 14:38:41 GMT

Hello i have this table

ID_SALER	PRODUCT	CATEGORIE	sales	CLIENT_PRODUCT
100	P1	c1	500	10
100	P2	c12	500	10
102	P1	c3	502	12
102	P2	c4	503	13

and i have variables $(P1) ET $( P2)

P1=sum({<CATEGORIE={'C1'},sales={'<700'}>}1)

P2=sum({<CATEGORIE={'C5'},sales={'<700 >200'}>}1)

SO I need to create simple table , in dimension ID_saler and Product

and in expression i need to add the variable with corresponding to value dimensions --> =$(PRODUCT)

ID_SALER	PRODUCT	EXPRESSION
100	P1	$(PRODUCT)	$(P1)
100	P2	$(PRODUCT)	$(P2)
102	P1	$(PRODUCT)	$(P1)
102	P2	$(PRODUCT)	$(P2)

but iwhen i excuted , the expression shows the text expression

sum({<CATEGORIE={'C1'},sales={'<700'}>}1)

sum({<CATEGORIE={'C5'},sales={'<700 >200'}>}1)

So i need to force the interpretation

Re: VARIABLE WITH DYNAMIC NAME

YoussefBelloum — Thu, 13 Sep 2018 14:43:21 GMT

Hi,

what is the content of the variable $(PRODUCT) ?

you are using two variables in your expression ?

Re: VARIABLE WITH DYNAMIC NAME

souadouert — Thu, 13 Sep 2018 14:48:14 GMT

Hello,

the idea is that the dynamic variable name according to the value of the dimension product

and P1 and P2

P1=sum({<CATEGORIE={'C1'},sales={'<700'}>}1)

P2=sum({<CATEGORIE={'C5'},sales={'<700 >200'}>}1)

Re: VARIABLE WITH DYNAMIC NAME

YoussefBelloum — Thu, 13 Sep 2018 14:49:57 GMT

a simple IF won't do the trick ?

if(PRODUCT='P1', $(P1), $(P2))

Re: VARIABLE WITH DYNAMIC NAME

souadouert — Thu, 13 Sep 2018 14:53:40 GMT

youssef I do not have the list of products,I must have as much product as dynamically variable

Re: VARIABLE WITH DYNAMIC NAME

YoussefBelloum — Thu, 13 Sep 2018 15:10:22 GMT

take a look at this:

Dynamic Variable Name in Chart | Qlik Community

Re: VARIABLE WITH DYNAMIC NAME

stigchel — Thu, 13 Sep 2018 15:11:03 GMT

The problem is that $ sign expansions are on a chart level and do not work with row by row dimension values. You probably need to use a pick match construction like =Pick(Match(Product,'P1','P2'),$(P1),$(P2)). To make this variable have a look at (and the links in there)

Re: Using Pick and Match for multiple calculations