topic Re: Set Analysis - Dimension as variable in QlikView

Set Analysis - Dimension as variable

robert_mika — Wed, 09 Dec 2015 16:51:16 GMT

I'm trying to enter variable in this way

=count({< vDate = { "=>$(=Date(Today(), 'DD/MM/YYYY'))<$(Date(Today()-100, 'DD/MM/YYYY'))" }>} id)

where vDate =date([DateTimeKey],'DD/MM/YYYY')

it works but if I change that to

vHelp

this works as well,

but vHelp = 1

or vMaxDate

of course in all situation Qlikview syntax yelling red underscore line

but the expression "works"

How?

I assume the result must be somehow skew as well

Can I use variable in this way?

Re: Set Analysis - Dimension as variable

simondachstr — Wed, 09 Dec 2015 16:57:11 GMT

In complex set analysis expressions, QlikView syntax sometimes marks the expression as incorrect, even though it works fine. As far as I am concerned, this is a known bug.

Re: Set Analysis - Dimension as variable

robert_mika — Wed, 09 Dec 2015 17:00:11 GMT

Thanks Martin.

I know about t his bug but in this situation this should not be evaluated at all throwing error.

Am I wrong?