Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Selection problem

Hi

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Selection problem

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

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

See also attached.

6 Replies
Not applicable

Re: Selection problem

Better you can try with set analysis.

/Murali

Not applicable

Re: Selection problem

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

TMF

MVP
MVP

Re: Selection problem

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

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

See also attached.

Re: Selection problem

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


talk is cheap, supply exceeds demand
Not applicable

Re: Selection problem

Hi

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

MVP
MVP

Re: Selection problem

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

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

Community Browser