topic Re: Help regarding creating variable in qliksense. in QlikView

Help regarding creating variable in qliksense.

Anonymous — Wed, 03 Jun 2015 05:18:41 GMT

hi all ,

i have developed dynamic measure selection in qlikview by making all my metrics into a line load then i called all the metrics as a feild of metrics . then in a bar chart i called the selection of that feild by getfeildseelction,,, and it was working fine now i wanna create the same in qliksense can some one help me with that pls.

Re: Help regarding creating variable in qliksense.

hic — Wed, 03 Jun 2015 05:43:39 GMT

You can do exactly the same in Qlik Sense. The variables are however not exposed in the UI, so you cannot define them there. But you can define them in the script.

You have a field called "Metric". Then you could define the a variable "vMetric" the following way:

Let vMetric = '=Only(Metric)' ;

and subsequently use this in your expressions.

HIC

Re: Help regarding creating variable in qliksense.

Anonymous — Wed, 03 Jun 2015 06:22:27 GMT

i am trying it the same way , but i am not getting it

i took my field Metrics into a filter , then i edited the expression in bar graph as sum($(vMetrics))

but i am not getting it .

Re: Help regarding creating variable in qliksense.

hic — Wed, 03 Jun 2015 10:55:14 GMT

And how have you defined the variable vMetrics?

HIC

Re: Help regarding creating variable in qliksense.

Anonymous — Wed, 03 Jun 2015 11:27:54 GMT

let vMetrics = '=Getfieldselections(Metrics)';

then in measure the expression is

sum($(vMetrics))

Re: Help regarding creating variable in qliksense.

hic — Wed, 03 Jun 2015 12:07:40 GMT

It works fine when I use it with the formulas you suggest...

The numbers (30+38+0=68) are indeed the Sum(Qty) for the different countries.

HIC

Re: Help regarding creating variable in qliksense.

Anonymous — Wed, 03 Jun 2015 12:38:25 GMT

please find the snapshot of the edit script is there any thing wrong in this?

Re: Help regarding creating variable in qliksense.

hic — Wed, 03 Jun 2015 12:48:17 GMT

Looks OK. But if you have spaces in the metrics, you need to use quotes when you use the variable:

sum("$(vMetrics)")

HIC

Re: Help regarding creating variable in qliksense.

Anonymous — Wed, 03 Jun 2015 12:51:32 GMT

tried this also , but i see no associations

Re: Help regarding creating variable in qliksense.

hic — Wed, 03 Jun 2015 13:10:28 GMT

Then you need to post some data. It works in my test data, also with spaces:

HIC

Re: Help regarding creating variable in qliksense.

Anonymous — Wed, 03 Jun 2015 13:18:43 GMT

thanks for your time in advance , please find the attachement

Re: Help regarding creating variable in qliksense.

Anonymous — Wed, 03 Jun 2015 13:31:05 GMT

finally we did that HIC , I am Very thankful to you , hope we continue to share our thoughts like this in future too .

thanks again.

Re: Help regarding creating variable in qliksense.

hic — Wed, 03 Jun 2015 13:36:34 GMT

Attached you will find a qvf file. Put it in C:\Users\xxx\Documents\Qlik\Sense\Apps.

HIC