topic Re: Pivot Table in QlikView

Pivot Table

NavinReddy — Tue, 01 Apr 2014 15:35:28 GMT

Dear All,

I created one Pivot table with one cycle group

its showing all business values but i want to show only 3 business only

=sum({<[New Level 1]=' Admin' or 'Ops' or 'Tech'>} [ Open Calls])

this expression not working

i want to filter These 3 only

where can i apply filters Group wise or Expression wise

Please guide me some one

Thanks In Advance

Niru

Re: Pivot Table

MK_QSL — Tue, 01 Apr 2014 15:37:54 GMT

SUM({<[New Level 1] = {'Admin','Ops','Tech'}>} [ Open Calls])

Create a Calculated Dimension

IF([New Level 1] = 'Admin' or [New Level 1] = 'Ops' or [New Level 1] = 'Tech', [New Level 1])

Tick Suppress When Value is NULL

and Expression

SUM([Open Calls])

IF(Match([New Level 1], 'Admin','Ops','Tech'), [New Level 1])

Tick Suppress When Value is NULL

and Expression

SUM([Open Calls])

Re: Pivot Table

PrashantSangle — Tue, 01 Apr 2014 15:39:24 GMT

Hi,

try this

=sum({<[New Level 1]={' Admin ', 'Ops' ,' Tech'}>} [ Open Calls])

Regards,

Re: Pivot Table

NavinReddy — Tue, 01 Apr 2014 15:49:01 GMT

Hi manish,

But i have cyclic group also

if it one field its working fine

but inside cycle group i have Three fields is there

If i select any field ,the 3 filters should apply

Regards,

Niru

Re: Pivot Table

MK_QSL — Tue, 01 Apr 2014 15:53:33 GMT

in this case, if you provide sample file would be great...

Re: Pivot Table

PrashantSangle — Tue, 01 Apr 2014 15:56:00 GMT

Hi,

Try Indirect Set Analysis.

P()

Regards,

Re: Pivot Table

NavinReddy — Tue, 01 Apr 2014 16:01:30 GMT

Hi,

sorry,this is client data i cant able to provide

where can i apply filter in Cycle Group or Expression

Thank you

Regards,

Niru

Re: Pivot Table

MK_QSL — Tue, 01 Apr 2014 16:02:53 GMT

You can definitely create a sample file having similar field name...

Re: Pivot Table

MK_QSL — Tue, 01 Apr 2014 16:21:33 GMT

If you have cyclic group as dimension,

use below in expression....this should work..

SUM({<[New Level 1] = {'Admin','Ops','Tech'}>} [ Open Calls])

Re: Pivot Table

NavinReddy — Tue, 01 Apr 2014 16:29:54 GMT

yes same, but expression not working

Re: Pivot Table

MK_QSL — Tue, 01 Apr 2014 16:34:28 GMT

What is in your cyclic group?

can you provide some 10 lines sample (dummy) data with same field name and Cyclic Group?