Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
robert_mika
Master III
Master III

Set Analysis - Dimension as variable

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

Capture.PNG

but the expression "works"

How?

I assume the result must be somehow skew as well

Can I use variable in this way?

2 Replies
simondachstr
Specialist III
Specialist III

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.

robert_mika
Master III
Master III
Author

Thanks Martin.

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

Am I wrong?