Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulsingh12
Contributor III
Contributor III

Set Analysis Issue

Hi,

I have a set analysis expression to calculate the YTD but it is just giving me MTD data instead.

if(UniqueId_Flag='1',

sum({<Year={"$(vYTDCurrentYear)"},Month={"<=$(vYTDMinMonth)"}>}([CostPerUnit )),

sum({<Year={"$(vYTDCurrentYear)"},Month={"<=$(vYTDMinMonth)"}>}[Variance]))

vYTDCurrentYear=Current YEar

vYTDMinMonth=Current Month


Regards,

Rahul

3 Replies
svinnakota
Creator
Creator

can you post a sample app along with the data

Santosh

ajaykakkar93
Specialist III
Specialist III

ajaykakkar93
Specialist III
Specialist III

hi i have made a small example by my understanding

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting