Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set analysis with YTD and Alternate State, how to

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

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

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

View solution in original post

2 Replies
Highlighted
Creator III
Creator III

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

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)

Highlighted
Not applicable

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

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

View solution in original post