topic Set Analysis Issue in QlikView

Set Analysis Issue

rahulsingh12 — Tue, 19 Jun 2018 07:15:54 GMT

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

svinnakota — Tue, 19 Jun 2018 07:42:41 GMT

can you post a sample app along with the data

Santosh

ajaykakkar93 — Thu, 21 Jun 2018 04:47:17 GMT

hi try this link

ajaykakkar93 — Thu, 21 Jun 2018 06:15:40 GMT

hi i have made a small example by my understanding