Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Filtering of pivot chart

Please see the attached document.

Hope that helps

Regards

Mhatim

10 Replies
thomas_skariah
Contributor III

Re: Filtering of pivot chart

Hi Tushar,

You can take help from the attached application.

Regards,

Tom

Not applicable

Re: Filtering of pivot chart

Thanks for quick reply.

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

jsingh71
Valued Contributor

Re: Filtering of pivot chart

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

Re: Filtering of pivot chart

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

Re: Filtering of pivot chart

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

Re: Filtering of pivot chart

sorry I did not understand your suggestion.

Not applicable

Re: Filtering of pivot chart

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

thomas_skariah
Contributor III

Re: Filtering of pivot chart

Hi Tushar,

You can use the following attached code in your script.

Regards,

Tom

Not applicable

Re: Filtering of pivot chart

Please see the attached document.

Hope that helps

Regards

Mhatim

Community Browser