topic Re: Need help in pivot table in QlikView

Need help in pivot table

Thu, 06 Nov 2014 10:11:24 GMT

Hi,

In a Pivot table how to control the dimention value for instance, I have a service type and the value is 1,2,3,4 and I would like to display only service type =1 in the pivot table.

is somebody can help.....

Regards

Joe

Re: Need help in pivot table

maleksafa — Thu, 06 Nov 2014 10:15:20 GMT

you need to filter it in your expression.

for example if your dimension is service type and let's assume that your expression is sum sales. then you need to modify your expression to be sum({<[service type]=1>}sales)

Re: Need help in pivot table

ashfaq_haseeb — Thu, 06 Nov 2014 10:27:21 GMT

Try this in expression

sum({<[service type]=1>}sales)

Or Try this as Calculated dimension

if([service type]=1,[service type])

Click on suppress null values for Dimension

Expression would be

sum(sales)

Regards

ASHFAQ

Re: Need help in pivot table

Thu, 06 Nov 2014 10:33:21 GMT

Hi,

use this

sum({[Service type]={1}>} Sales)

Re: Need help in pivot table

Thu, 06 Nov 2014 10:34:59 GMT

Thanks Malek for your reply,

in the expression i have added 1 only, the data is already calculated, so just show the the Service type value 1 only.

Re: Need help in pivot table

maleksafa — Thu, 06 Nov 2014 10:38:45 GMT

i didn't get you very well, did it solve your problem or you are still facing the same challenge?

Re: Need help in pivot table

Thu, 06 Nov 2014 11:28:14 GMT

Hi, this is works fine....

Thanks a lot for your support.

if([service type]=1,[service type])

Click on suppress null values for Dimension