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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?