topic Re: Filter in QlikView

Filter

Sat, 20 Dec 2014 10:13:33 GMT

Hello,

I'm having a pivot table with expression which has negative, 0 and positive values. I want to give a button and on click of that button I want to have my users see only the rows with this expression having 0 values. How would I do that?

Re: Filter

MK_QSL — Sat, 20 Dec 2014 10:32:55 GMT

Consider you have below data

Load * Inline

[

Item, PurchaseCost, SalesCost

A, 100, 100

B, 120, 150

C, 90, 135

D, 1200, 1100

E, 1000, 1100

F, 500, 500

G, 200, 200

];

and after clicking the button, you want to show only Items A,F,G where TotalPurchaseCost and TotalSalesCost are same.. You can use as below

Create a button

Add Action

Select in Field

Field

Item

Search String

='=SUM(PurchaseCost)-SUM(SalesCost)=0'

Re: Filter

Sat, 20 Dec 2014 10:57:42 GMT

Thanks Manish!! It works. I want to use the same button to toggle between 0 and Non zero values, is this possible?

Re: Filter

alkesh_sharma — Sat, 20 Dec 2014 11:05:26 GMT

Put the same expression

For Negative Values:

=SUM(PurchaseCost)-SUM(SalesCost)<0'

For Positive Values

=SUM(PurchaseCost)-SUM(SalesCost)>0'

Re: Filter

Sat, 20 Dec 2014 11:07:48 GMT

How would first click of a button be positive and second click of a button be negative? I want to use only one button but different action.

Re: Filter

alkesh_sharma — Sat, 20 Dec 2014 11:23:00 GMT

Create Two Buttons, Place them exactly over one another. and conditional hide and show them accordingly.

Re: Filter

alkesh_sharma — Sat, 20 Dec 2014 11:29:23 GMT

Please find the file attached for your reference.