topic Re: Ignore Selection made in a list box in QlikView

Ignore Selection made in a list box

Tue, 19 Jun 2012 09:58:10 GMT

Hi!

I've a Pivot table which i want to ignore a selection made by a list box.

Should this be done by set analysis?

The list box list all SITEID's and I want the user to do a selection but it shouldn't affect the pivot table (i want it to show all siteids)

//BR
Patrik

Re: Ignore Selection made in a list box

Miguel_Angel_Baeyens — Tue, 19 Jun 2012 10:02:41 GMT

Hi Patrik,

Generally speaking, the following syntax will ignore selections in field SITEID. The right part is empty on purpose, it's not a typo.

Sum({< SITEID = >} Value)

Hope that helps.

Miguel

Re: Ignore Selection made in a list box

Tue, 19 Jun 2012 10:44:18 GMT

Sorry for my stupidity, but where should i use this?

Re: Ignore Selection made in a list box

Miguel_Angel_Baeyens — Tue, 19 Jun 2012 11:07:24 GMT

Hi Patrik,

No stupidities here, we are all learning. In the pivot table, as in almost any other chart, there are two "mandatory" things: dimensions and expressions. In this case, the code above would be the expression.

Hope that makes sense.

Miguel

Re: Ignore Selection made in a list box

Tue, 19 Jun 2012 11:30:55 GMT

Hello!

I can't get it to work, In this case the dimension is SITEID and SITEID is text so can you still use sum?

//BR
Patrik

EDIT: My head seems to come to it senses right now

But one question. can this be applied on a table that is text? (regarding the SUM action)

Re: Ignore Selection made in a list box

Miguel_Angel_Baeyens — Tue, 19 Jun 2012 11:49:00 GMT

Hi,

Nope, the Sum() function will return null "-" when the value is not numeric. But then, why do you want to use a pivot table? You could upload some sample data so we can figure it out.

Miguel

Re: Ignore Selection made in a list box

Tue, 19 Jun 2012 12:18:08 GMT

Hmm I'm stuck.

Simply I want the whole pivot table to ignore the selection of SITEID (all other selections, date etc i want to work)

Re: Ignore Selection made in a list box

Miguel_Angel_Baeyens — Tue, 19 Jun 2012 12:24:53 GMT

Hi Patrik,

You better upload some sample data so we can figure out what do you expect. Expressions as shown above should work, but if they are not, I'm afraid I cannot go any further.

Miguel