Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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

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

See also attached.

View solution in original post

6 Replies
Not applicable
Author

Better you can try with set analysis.

/Murali

Not applicable
Author

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

TMF

swuehl
MVP
MVP

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

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

See also attached.

View solution in original post

Gysbert_Wassenaar

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
Author

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

swuehl
MVP
MVP

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

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