topic Re: Filtering of pivot chart in QlikView

Filtering of pivot chart

Wed, 31 Oct 2012 02:45:12 GMT

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 Code	Document No	Item Code	Cost Price	Sales Price (BD)	Sales Return
BR001	1	STK001	1,000.00	9,000.00	500.00
BR002	1	STK005	1,000.00	8,000.00	0.00
BR003	2	STK004	1,000.00	4,000.00	7,000.00
BR004	1	STK006	8,000.00	15,000.00	0.00

Filtering records where Sales Return is ZERO

Location Code	Document No	Item Code	Cost Price	Sales Price (BD)	Sales Return
BR002	1	STK005	1,000.00	8,000.00	0.00
BR004	1	STK006	8,000.00	15,000.00	0.00

Filtering records where Sales Return is not ZERO

Location Code	Document No	Item Code	Cost Price	Sales Price (BD)	Sales Return
BR001	1	STK001	1,000.00	9,000.00	500.00
BR003	2	STK004	1,000.00	4,000.00	7,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.

Re: Filtering of pivot chart

thomas_skariah — Wed, 31 Oct 2012 02:54:55 GMT

Hi Tushar,

You can take help from the attached application.

Regards,

Tom

Re: Filtering of pivot chart

Wed, 31 Oct 2012 03:08:17 GMT

Thanks for quick reply.

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

Re: Filtering of pivot chart

jsingh71 — Wed, 31 Oct 2012 05:15:21 GMT

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....

Re: Filtering of pivot chart

Wed, 31 Oct 2012 05:37:47 GMT

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

Re: Filtering of pivot chart

Wed, 31 Oct 2012 09:24:43 GMT

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.

Re: Filtering of pivot chart

Wed, 31 Oct 2012 09:26:38 GMT

sorry I did not understand your suggestion.

Re: Filtering of pivot chart

Wed, 31 Oct 2012 09:27:44 GMT

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

Re: Filtering of pivot chart

thomas_skariah — Wed, 31 Oct 2012 09:55:33 GMT

Hi Tushar,

You can use the following attached code in your script.

Regards,

Tom

Re: Filtering of pivot chart

Wed, 31 Oct 2012 10:45:19 GMT

Please see the attached document.

Hope that helps

Regards

Mhatim

Re: Filtering of pivot chart

Wed, 31 Oct 2012 11:54:17 GMT

Once again Thanks,

After following instruction from word documet when I had created list box and add below mention expression now I am able to filter the records.

You guys are great help to qlickview learner.

God Blass you all.