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

Filtering of pivot chart

Hello All,

I would like to learn how to filer pivot chart result.

example.

In my below mention example, I would to filter result base on selection.

Normal Display:

Location CodeDocument NoItem CodeCost PriceSales Price (BD)Sales Return
BR0011STK0011,000.009,000.00500.00
BR0021STK0051,000.008,000.000.00
BR0032STK0041,000.004,000.007,000.00
BR0041STK0068,000.0015,000.000.00

Filtering records where Sales Return is ZERO

Location CodeDocument NoItem CodeCost PriceSales Price (BD)Sales Return
BR0021STK0051,000.008,000.000.00
BR0041STK0068,000.0015,000.000.00


Filtering records where Sales Return is not ZERO

Location CodeDocument NoItem CodeCost PriceSales Price (BD)Sales Return
BR0011STK0011,000.009,000.00500.00
BR0032STK0041,000.004,000.007,000.00

To do that:

It will be greate if we can do filtering through User defined value in list box, if not may be any other better way.

I had attached example and modified my main post with result.

Thanks in advance.

1 Solution

Accepted Solutions
Not applicable
Author

Please see the attached document.

Hope that helps

Regards

Mhatim

View solution in original post

10 Replies
thomas_skariah
Creator III
Creator III

Hi Tushar,

You can take help from the attached application.

Regards,

Tom

Not applicable
Author

Thanks for quick reply.

Sorry, I am using personal edition so I am not able to open your file.

jsingh71
Partner - Specialist
Partner - Specialist

Go the chart property---->Dimention Tab-------> select 'Used Dimentions' and then give the condition of each Dimention.

Ex.     if([Sales Return]=0,[Location Code])  and so on.. same thing do for non zero....

Not applicable
Author

Hi,

Based on Tom's suggestion, you can create an extra field to tag zero and non zero sales.

Example

if(Quantity=0,'Null','Not Null') as Filter

Then you can show this field as a value in a list box.

Credit Tom if it helps you.

Regards,

Janzen

Not applicable
Author

appreciate all of you guys for suggstions.

I had tried them on my example but still struggling in getting result.

I am adding example files, I belive that way I can exaplin what I am looking for ?

As mention earlier I am using personal edition so if you are attaching edited example then let me know how to open or send me suggstion with I will be abel to get result.

Not applicable
Author

sorry I did not understand your suggestion.

Not applicable
Author

I had tried to create list box with formula which you have mention but result is differing from requirements.

thomas_skariah
Creator III
Creator III

Hi Tushar,

You can use the following attached code in your script.

Regards,

Tom

Not applicable
Author

Please see the attached document.

Hope that helps

Regards

Mhatim