topic issue with using variables in a chart in QlikView

issue with using variables in a chart

Fri, 23 Dec 2011 05:47:00 GMT

Hi,

I am using QV 10 desktop and it seems that the variables don't seem to fit in the chart expressions. I get a red underline on the variable. i have used a QVS file to load variabes.

CODE: But when i use this variable in the Chart - expression tab, data is not displayed.

SET vIncl = "'cidentId = '";

SET vExcludeDates = "'MonthYear= , Week = , Day = '";

count({$< $(vExcl), $(vIncl) >} distinct AblemID)

I get an error in the above expression.

issue with using variables in a chart

vijay_iitkgp — Fri, 23 Dec 2011 05:55:33 GMT

I think you are defining the variables in wrong way. Please go to the Settings---->Variable overview to see your variable.

Regards

Vijay

issue with using variables in a chart

Fri, 23 Dec 2011 05:56:57 GMT

i m using a QVS file to define variables. There is no with the load as QlikView is able to load it without any errors.

issue with using variables in a chart

vijay_iitkgp — Fri, 23 Dec 2011 05:59:12 GMT

There is nothing wrong in syntex thts'y qlikview is not throwing any error. But if you see the variable overview then you can find what r u setting the variable values

Re: issue with using variables in a chart

Fri, 23 Dec 2011 06:10:12 GMT

fine, i will check with the syntax. my original question was QV 10 throws an error when we use variables in a chart expression.

has any body tried using variables in a chart expression in the foll. way?

count({$< $(vVAR1), $(vVAR2) >}distinct EmblemID)

when i use this in a chart expression, there is a red underline on vVAR1.

Re: issue with using variables in a chart

jagan — Mon, 06 Feb 2012 12:04:34 GMT

Hi,

Try this

=count({$< $(=(vExcl& ',' & vIncl) >} distinct AblemID)

Regarsd,

Jagan.