topic Set analysis in QlikView

Set analysis

Tue, 01 Jul 2014 05:53:52 GMT

Requirement- yr and month is present eg- 11/2013 on clicking this ... ..> show the sum of budget from Jan 2013 till nov 2013 should display...

Please let me know how to do it .

Thanks

Kamal

jagan — Tue, 01 Jul 2014 05:59:14 GMT

Hi,

Arrive a date field in script like this

LOAD

MakeDate(Right(MonthFieldName, 4), Left(MonthFieldName, 2)) AS DateFieldName

FROM DataSource;

Now use this expression

=sum({<MonthFieldName=, YearFieldName=, DateFieldName={'>=$(=YearStart(Max(DateFieldName)))<=$(=Date(Max(DateFieldName)))'}>} MeasureName)

Note: MonthFieldName, YearFieldName, MeasureName with your actual field names.

Hope this helps you.

Regards,

jagan.

Tue, 01 Jul 2014 19:33:05 GMT

thank you so much for you response Jagan this really helps me

jagan — Wed, 02 Jul 2014 01:39:00 GMT

Hi Kamal,

Please close this thread by clicking Correct Answer button to my post. This helps others in knowing the answer for similar scenarios.

Regards,

jagan.