topic Re: Set analysis Expression in QlikView

Set analysis Expression

bharatkishore — Tue, 31 Oct 2017 07:34:10 GMT

Hi All,

I have one straight table chart and i have written this set analysis expression.

The problem is the expression is not working it is still showing 2017 values but it should show 2016 december values.

The expression is:

=SUM({<MonthYear={">=$(=Date(AddMonths(Max(MonthYear), -1)))<=$(=Date(Max(MonthYear)))"}>}IB)

Attached app for reference.

Thanks,

Bharat

Re: Set analysis Expression

mdmukramali — Tue, 31 Oct 2017 07:38:52 GMT

Hi,

You have to exclude the selection of the Month Field from Expression.

try the below Expression.

=SUM({<MonthYear={">=$(=Date(AddMonths(Max(MonthYear), -1)))<=$(=Date(Max(MonthYear)))"},Month=>}IB)

if you want only previous Month then try below expression.

=SUM({<MonthYear={">=$(=Date(AddMonths(Max(MonthYear), -1)))<$(=Date(Max(MonthYear)))"},Month=>}IB)

Thanks,

Mukram

Re: Set analysis Expression

bharatkishore — Tue, 31 Oct 2017 07:48:32 GMT

Hi Mukram,

Thanks for you reply. Pls find the attached app.

Here if i select Jan the data is not showing in the graph.. The expression is working fine and the values are correct but i want to see Jan in chart..

Pls let me know if you need anything more..

Re: Set analysis Expression

mdmukramali — Tue, 31 Oct 2017 07:52:21 GMT

Hi Bharat,

find the attached App.

Re: Set analysis Expression

bharatkishore — Tue, 31 Oct 2017 07:58:35 GMT

Hi Mukram,

Thanks for your time but the format i need is the below one:

In your app we can see only December but the dimesions should be selected months for example say Jan. .I need to see jan dimesion but the expression should always show only december values.

Please let me know if you need anything more..

Re: Set analysis Expression

mdmukramali — Tue, 31 Oct 2017 08:30:02 GMT

HI Bharat,

In the Set Analysis, we are applying the condition on Month also so if you select Jan from Month it will show you Dec in the chart,

maybe you can try to create a new field in the script like what I did in the attached application,

Re: Set analysis Expression

sunny_talwar — Tue, 31 Oct 2017 08:41:31 GMT

May be this

=Sum({<MonthYear={">=$(=Date(AddMonths(Max(MonthYear), -1)))<$(=Date(Max(MonthYear)))"}, Month>}IB)