topic Re: Filtering Value in Pivot table in QlikView

Filtering Value in Pivot table

dsharmaqv — Wed, 25 Nov 2020 16:16:04 GMT

I want to display the value >=500 in pivot table also i am displaying partial sum by column A and B.

A	B	C	D	F	Balance
GBM	IND	EQ	Portfolio1	D1	555
GBM	IND	EQ	Portfolio2	D2	666
GBM	IND	EQ	Portfolio3	D3	777
GBM	IND	EQ	Portfolio4	D4	888
GBM	FX	US	Portfolio6	D5	999
GBM	FX	US	Portfolio5	D6	111

Can some one assist me to get the required result.

millan123 — Thu, 01 Sep 2016 09:59:30 GMT

HI,

U can set the values in dimension limit tab there u can put >=500 then u will get

fashid — Thu, 01 Sep 2016 10:01:11 GMT

Check partial sums in presentation tab for the respective columns

vikasmahajan — Thu, 01 Sep 2016 10:01:46 GMT

you can implement Re: what if

Vikas

HirisH_V7 — Thu, 01 Sep 2016 10:09:32 GMT

Hi,

May be like this,

If(Sum({<A={'GBM'},B={'IND','FX'}>}Sales)>500,
Sum({<A={'GBM'},B={'IND','FX'}>}Sales))


If(Your Expression >500,Your Expression)

HTH,

Hirish

sunny_talwar — Thu, 01 Sep 2016 10:48:00 GMT

Would you be able to share a sample to look at this? and also share what the expected output is?

dsharmaqv — Thu, 01 Sep 2016 11:20:59 GMT

A	B	C	D	F	Balance
GBM	IND	EQ	Portfolio1	D1	555
GBM	IND	EQ	Portfolio2	D2	666
GBM	IND	EQ	Portfolio3	D3	777
GBM	IND	EQ	Portfolio4	D4	888
	Total				2886
GBM	FX	US	Portfolio6	D5	999
	Total				999
Total					3885

Expected Output

sunny_talwar — Thu, 01 Sep 2016 11:24:48 GMT

Have you tried this?

Dimension:

Expression

Sum(Aggr(If(Sum(Balance) >=500, Sum(Balance)), A, B, C, D, F))

dsharmaqv — Thu, 01 Sep 2016 11:51:35 GMT

Thanks Sunny....

dsharmaqv — Fri, 02 Sep 2016 06:39:26 GMT

Hi clark, Option is not available for pivot table