Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Sum if 2 conditions with selections

hi,

now i have such formula :

sum({<Year={'$(=max(Year)-1)'}>} [liters purchased])

so when i have selected Year 2011, this formula me returns previous year 2010, not looking that i have selected Y2011. - it's OK.

now i want to add additional rule , also that should not look at selections. i have Local or Export sales, so i would like to add additional rule in this formula , is it possible ? so should be something like that : {<Year={'$(=max(Year)-1)'}>} { .... local...} [ liters purchased] .. ?

1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Sum if 2 conditions with selections

hei

yes you can add as much conditions as you like

it will look like

sum({<Year={'$(=max(Year)-1)'},KindOfSales={"local"}>} [liters purchased])

2 Replies
lironbaram
Honored Contributor II

Sum if 2 conditions with selections

hei

yes you can add as much conditions as you like

it will look like

sum({<Year={'$(=max(Year)-1)'},KindOfSales={"local"}>} [liters purchased])

Not applicable

Sum if 2 conditions with selections

Super, Thanks !

it works Smiley Happy