Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Variables

Hi.

I have the following issue. 

I created a pretty complex variable $(zComplex) that I would like to use in a Measure's expression ... such as 

Consider the value of $(zComplex) only if the Date is greater than 1/1/2020.

I tried

if(Date>='01/01/2020',$(zComplex),null()) ... but I get a nil outcome. 

I neither want to use a modification in the data editor, nor to use set analysis in the actual code of the variable.

Could you please help?

 

 

Thanks

Labels (1)
7 Replies
Highlighted
Employee
Employee

What expression is inside your variable ?

Highlighted
Contributor II
Contributor II

Several set analyses expressions embedded in distinct counts
Highlighted
Employee
Employee

It is hard to understand the issue if we can't see the whole picture

Highlighted
Contributor II
Contributor II

Happy to set up a webex if you could and if I would not take too much of ur time
Highlighted
Employee
Employee

Sure, I have time now

Highlighted
Contributor II
Contributor II

Hi. Am on the east coast and did not reply to your latest message. If you would have some time between now and 6:00pm EDT, I could send a link for a quick vdo conf. Again, I don’t want to take too much of your time. Thanks


Highlighted
Employee
Employee

Sorry, was not checking over the weekend. I am in Sydney, Australia, so my daytime is best