topic Re: use variable in expression in QlikView

use variable in expression

alec1982 — Fri, 23 Oct 2015 02:30:10 GMT

hi all,

I have a table with sales amounts of each department..the department names are the headers and the sales amounts are the rows..

Department 1 Department2 Department3

1000 2000 2200

I have created an inline table with the names of the departments and created a variable to have get selected value of the department name.

trying to use a variable in expression to switch the column name

sum([$(varDepartment)]

so when I change my selection I get the selected department sales... but it is not working..

any idea..

sunny_talwar — Fri, 23 Oct 2015 02:35:07 GMT

See if the attached helps.

Best,

Sunny

jagan — Fri, 23 Oct 2015 02:50:26 GMT

HI,

Try like this

Variable Declaration:

vDepartment = Depatment 1

Expression =Sum([$(=vDepartment)])

Hope this helps you.

Regards,

Jagan.

lironbaram — Fri, 23 Oct 2015 02:51:55 GMT

you can use this

=$(='sum([' & $(varDepartment) & '])')

this should do the trick

but if i where you i will do a crosstable load on the original table

to get the table to this structure:

DivisionName,Sales

Division1,1000

Divison2,2000

Divison3 ,2200

then use a list box of the division field for selecting specific division

alec1982 — Fri, 23 Oct 2015 03:06:32 GMT

your samples work exactly as i need but it is not working on my data within QlikSense....

alec1982 — Fri, 23 Oct 2015 03:11:17 GMT

thank you.. this worked for me... I cannot use cross table here as the data is used somewhere else too.. so I was looking for a quick solution..

thank you for your help!

sunny_talwar — Fri, 23 Oct 2015 03:12:08 GMT

I thought you wanted to do this in QlikView because you posted this on QlikView forum. Not sure how Qlik Sense works for the same.