topic Re: How to Hide Values based on Pivot Table? in QlikView

How to Hide Values based on Pivot Table?

Wed, 16 May 2012 23:00:46 GMT

I am finding diffcult to hide values which is more than $15000 on a Sum? any ideas would be appreciated.

I doing a total on a particular column and a subtotal,but at the same time based on the sub total,i would like to hide any values less than certain amount...eg:- $15000..

thanks for your help

Re: How to Hide Values based on Pivot Table?

Wed, 16 May 2012 23:05:27 GMT

attaching a qvw...

Re: How to Hide Values based on Pivot Table?

sivarajs — Thu, 17 May 2012 06:02:47 GMT

check the attached file

Re: How to Hide Values based on Pivot Table?

Thu, 17 May 2012 12:26:18 GMT

Thanks for your time...but i was expecting...like..

eg:- if you search by 18011 it does have two values ie...173k and 3895...i would like to keep those two rows but only if hte sum of those two is less than 15k then hide it...that is where my problem is...

thanks for your help.

Re: How to Hide Values based on Pivot Table?

Thu, 17 May 2012 12:55:40 GMT

Hi,

I am confused whether u want to exclude value with more than 15000 or less than 15000.

Use the below expression for excluding value less than 15000

Instead of using SONUM dimension directly create a calculated dimension

IF(aggr(sum(BACKORDERQTY_1),SONUM) >=15000 , SONUM)

Regards

Ankur

Re: How to Hide Values based on Pivot Table?

Mon, 21 May 2012 14:48:15 GMT

thanks it works...thanks for your help on this...

Re: How to Hide Values based on Pivot Table?

Tue, 19 Jun 2012 22:38:14 GMT

now i seem to have different problem on the same issue..how do i place filter on the backorderqty_1

if there are 3 records

sonum backorderqty_1 ship?

1 10000 1

1 5000 0

1 2000 1

2 16000 1

3 19000 0

now the values i should reterive is

2 16000 1

but i am having

1 12000

2 16000

i am having great diffculty to fix it..

//IF(aggr(sum(BACKORDERQTY_1),SONUM) >= 15000, SONUM)

// IF(aggr(distinct sum(BACKORDERQTY_1),SONUM) >=15000, SONUM)

//IF(aggr(SHIP=0,sum(BACKORDERQTY_1),SONUM) >=15000, SONUM)

//IF(aggr(IF (SHIP=0,sum(BACKORDERQTY_1),SONUM)) >=15000, SONUM)

none of these work..

Thanks for your reply