topic Re: Set analysis with YTD and Alternate State, how to in QlikView

Set analysis with YTD and Alternate State, how to

Thu, 18 Sep 2014 14:23:26 GMT

Hi,

I really need some help 😞

Objective:

To have a straight tabel with colomms who show values bases on different altenate states.

Current Expression

=SUM({<Year={'$(vMaxYear)'},Datum={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}Sales)

How can I adjust the expression above to include a alternate state.

Alternate state 1 = All data (lets call is alternate state "Everybody")

Alternate state 2 = Data selected Customer (lets call this alternate state "CustomerSelected")

Feedback would be appreciated!

Kind regards

Re: Set analysis with YTD and Alternate State, how to

Anonymous — Thu, 18 Sep 2014 18:17:06 GMT

I don't see a reason for alternate state here,

for the "Everybody" you can use

=SUM({<Year={'$(vMaxYear)'},Datum={'<=$(vMaxDate)'},Month=,Day=,MonthYear=,Customer=>}Sales)

for the "Customer Selected" the expression you provide, customer will be filtered based on your selection.

=SUM({<Year={'$(vMaxYear)'},Datum={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}Sales)

Re: Set analysis with YTD and Alternate State, how to

Fri, 19 Sep 2014 12:40:36 GMT

He Konstantins,

I believe you may have "Everybody" and "Customer Selected" formulas "the other way around" but most important, you gave me the right directions. I solved my issue now and have a fine working straight table!

Thx

Arjen