topic Re: How to write a set analysis in QlikView

How to write a set analysis

kunkumnaveen — Fri, 05 Oct 2018 10:02:24 GMT

Hello all,

I need to show year start month to selected month sales .

if apr-17 is selected then jan 17 to apr-17 sales need to be shown in bar chart

How to write this in set analysis...

Thanks

Re: How to write a set analysis

andrey_krylov — Fri, 05 Oct 2018 13:22:27 GMT

Hi, try this

{< Month_Year, Date = {"$(='>=' & YearStart(Max(Date)) & '<=' & Date(Max(Date)))"} >}

Re: How to write a set analysis

kunkumnaveen — Mon, 08 Oct 2018 09:18:07 GMT

If only a year 2017 is selected then jan to dec Months are showing as below

sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}>}Sales)

But when i selected any month (Apr-17) instead of showing Jan-17 to Apr-17 i getting below screen

I think i need to change some where in my expression

sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}>}Sales)

Any help regarding this

Re: How to write a set analysis

kunkumnaveen — Mon, 08 Oct 2018 11:39:09 GMT

Any help on this issue plz

Re: How to write a set analysis

andrey_krylov — Mon, 08 Oct 2018 11:51:30 GMT

The better way is to create a textbox and see what these expressions give you

=floor(YearStart(Max(Floor_Month_year)))

=floor(Max(Floor_Month_year))

and what you have in Floor_Month_year

Re: How to write a set analysis

kunkumnaveen — Mon, 08 Oct 2018 12:14:22 GMT

Hello,i did check that

both the expression are giving the correct values individually but when i combined them in a set analysis i am not getting the required output .

Did u see any issue in my expression .

sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}>}Sales)

before any month selection it is working fine ,the issue is when i select any month

Re: How to write a set analysis

andrey_krylov — Mon, 08 Oct 2018 12:20:37 GMT

Can you post these values?

Re: How to write a set analysis

kunkumnaveen — Mon, 08 Oct 2018 12:36:50 GMT

When only Year(2017) is selected

when Year(2017) and Month(Apr) is selected

Re: How to write a set analysis

juraj_misina — Mon, 08 Oct 2018 13:18:52 GMT

You also need to ignore your other filters, because your expression is now filtered by the Floor_Month_year field:

sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}, Year, Month, YearMonth, Datenum>}Sales)

Re: How to write a set analysis

andrey_krylov — Mon, 08 Oct 2018 13:32:10 GMT

Hi, Juraj. You're right, I just can't figure out how the april selection gives january in the chart

Re: How to write a set analysis

kunkumnaveen — Tue, 09 Oct 2018 03:35:25 GMT

Thanks Juraj, i did the same and it worked out

Re: How to write a set analysis

kunkumnaveen — Tue, 09 Oct 2018 03:36:17 GMT

Hello Andrey, thanks for going through my issue ,.....