Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
crusader_
Partner - Specialist
Partner - Specialist

Multiple selection button

Hi,

I have a Chart as a pivot table, which has 3 dimesnions and several expressions. The result of expressions 1 or 0 only.

Looks like below:

Dim1      Dim2      Dim3      Exp1      Exp2     Exp3     Exp4

Order1    Name1    Cargo1        0           0            1          0

Order1    Name1    Cargo2        0           1            0          0

Order1    Name2    Cargo3        0           0            0          0

Order2    Name1    Cargo4        1           0            1          0

Order3    Name1    Cargo5        0           0            0          0

Order3    Name2    Cargo6        0           0            0          1


I need to make a button which select all row which contains at least one "1".

The result should be:

Dim1      Dim2      Dim3      Exp1      Exp2     Exp3     Exp4

Order1    Name1    Cargo1        0           0            1          0

Order1    Name1    Cargo2        0           1            0          0

Order2    Name1    Cargo4        1           0            1          0

Order3    Name2    Cargo6        0           0            0          1


Thanks in advance for help.

Regards,

Andrei

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.  Created additional expression and hidden in the table.

Regards,

Jagan.

View solution in original post

6 Replies
Not applicable

Just go to the presentation tab and check "Supress Zero Values" and supress missing values.

crusader_
Partner - Specialist
Partner - Specialist
Author

Dear Deepak,

Thanks for your response, but I need exactly a button which "Supress Zero Values" and turns back.

Is it possible to make such Action on Button object?

Andrei

tresesco
MVP
MVP

Create two charts one with supression enabled and another without. Then use a button to hide/unhide chart.

PFA

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.  Created additional expression and hidden in the table.

Regards,

Jagan.

crusader_
Partner - Specialist
Partner - Specialist
Author

Thanks a lot!

That's exactly what I wanted!

crusader_
Partner - Specialist
Partner - Specialist
Author

Nice solution!

Thanks for help!