Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

spetushi
New Contributor III

QlikView - Reusing Expression with Variable as a Variable

Hello,

I am trying to convert the following expression in a variable (I have referenced the steps shown in: Reusing Expressions), but the chart is not calculating. I have used $-sign expansion as instructed, but no success. Could this be due to the 'vInitial' variable I have within the expression, or the hidden dates?

If(vInitial = 1, (Num(Count(Distinct If(([Initial Receipt Date] >= %CPStartDate AND [Initial Receipt Date] <= %CPEndDate ) OR ([Follow-Up Date]>= %CPStartDate AND [Follow-Up Date] <= %CPEndDate  AND Significant = 'Yes'), RecordID))


Thanks,

Sokol

1 Solution

Accepted Solutions
spetushi
New Contributor III

Re: QlikView - Reusing Expression with Variable as a Variable

Please ignore. I was referencing incorrect variable name.


Thanks,

Sokol

3 Replies
vishsaggi
Esteemed Contributor III

Re: QlikView - Reusing Expression with Variable as a Variable

What are the date formats of your ReceiptDates/FollowupDate and your %CPDates?

nadeemsmarty
Valued Contributor

Re: QlikView - Reusing Expression with Variable as a Variable

Please post your expression along with the sample application

spetushi
New Contributor III

Re: QlikView - Reusing Expression with Variable as a Variable

Please ignore. I was referencing incorrect variable name.


Thanks,

Sokol