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: 
Not applicable

Filter by Negative values in a pivot table

Hi There,

I have pivot chart containing a lot of production data.

One of the expressions is in the chart shows the number of Items available based on a wee bit of set analysis.

There are a number of other expressions shown too that provide detailed information on the same row.

The client would like to be able click a button and only see items that are of negative value. Then unclick it and see everything again.

I can't think of a way to do this. Is it possible?

I kind of got it working with Dimension Limits but was wondering if there was another more flexible way.

eg. table

Item Name | Sales Prior Period | Sales Current | Stock Available

Item 1                    20                         18                    5

Item 2                    14                         14                    -2

Item 3                    11                         13                    -5

Item 4                    9                           12                    7

Click a button and only see Items 2 and 3.

Anyway ideas?

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

See the qvw attached.

Two buttons are used, showing/hiding by using var values in layout/conditional tab.

Please mark answered if this helps !!!

Regards

View solution in original post

3 Replies
Not applicable
Author

Hi,

Please see attached.

Regards,

Janzen

Not applicable
Author

Hi,

See the qvw attached.

Two buttons are used, showing/hiding by using var values in layout/conditional tab.

Please mark answered if this helps !!!

Regards

Not applicable
Author

Brilliant. Thanks very much for you help.

Sorry for my delay in responding.