topic Re: Double step in set analysis in QlikView

Double step in set analysis

Fri, 03 Aug 2012 08:55:24 GMT

Hello to everyone who is going to read my new question.

Let us imagine that I have 4 kind of store shelves : A - B - C - D and many customers.

In one tab, I would like to show the total amount paid by each customers in shelves A and C.

That's what I've written so : =sum({<[Shelve]={'A','C'}>}count_total)

But, when I select one shelve (for example A), the graph doesn't move. It still shows me the total amount for the two shelves (logical).

Is it possible to show :

- total amount in shelves A and C when I don't select anaything ;

- total amount in the shelve I select when I choose A or C ?

Thanks for your help.

MayilVahanan — Fri, 03 Aug 2012 15:18:09 GMT

You can use if condition like this,

=if(match(getfieldSelections(año),2009,2011),sum({<año = {$(=getfieldSelections(año))}>}instalacion), Sum({<año = {2009,2011}>}instalacion))

Hope it helps

mikecrengland — Fri, 03 Aug 2012 15:56:36 GMT

Put a ' * ' before the ' = '

=sum({<[Shelve] * ={'A','C'}>}count_total)