topic Selection problem in QlikView

Selection problem

Fri, 23 Nov 2012 10:22:27 GMT

I have a chart that has to be linked to some filters and disable from others. I try to use alternate states but that solution disable all the filters. I want only to disable some of them.

As an example: My chart has to be linked to Year and Month of the default state but when I click on, let's say ProductName, I want that the ProductName doesn't appear in current selections. Anybody knows how can I do that?

Thanks in advance.

Best regards,

TMF

Re: Selection problem

Fri, 23 Nov 2012 10:44:20 GMT

Better you can try with set analysis.

/Murali

Re: Selection problem

Fri, 23 Nov 2012 10:50:42 GMT

I already try this but it didn't work...

TMF

Re: Selection problem

swuehl — Fri, 23 Nov 2012 10:51:58 GMT

You can use set analysis to reference another alternate state explicitely, like

sum({<Dim3=[AS1]::Dim3>}Expression1)

Re: Selection problem

Gysbert_Wassenaar — Fri, 23 Nov 2012 10:52:45 GMT

I think this discussion will help you understand how you can use alternate states in set analysis expressions.

Re: Selection problem

Fri, 23 Nov 2012 11:44:51 GMT

Thanks for your replies!

I need help here:

I have this in a caption:

='Product Sales, '&Only(Mes)&' '&Only(Ano)

However, this caption is in a chart that has one alternate state and I want the month and year of this caption from default state. I can I use the same strategy here?

TMF

Re: Selection problem

swuehl — Fri, 23 Nov 2012 12:43:49 GMT

Ok, I think you just need to reference the default state in your set expression:

='Product Sales, '& only({$} Mes) & ' ' & only({$} Ano)