# 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
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

Tags (5)
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

2 Replies
Highlighted
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