Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I think you are defining the variables in wrong way. Please go to the Settings---->Variable overview to see your variable.
Regards
Vijay
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.
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
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.
Hi,
Try this
=count({$< $(=(vExcl& ',' & vIncl) >} distinct AblemID)
Regarsd,
Jagan.