topic Re: Pivot Chart in QlikView

Pivot Chart

bharatkishore — Fri, 08 May 2015 05:53:41 GMT

Dear All,

I have a issue related to pivot chart..Hope i will get the help..

I have two dimensions one is name and other one is task_type...In both the dimensions i have some 10 fields and i required only 3 fields from name and only 4 fields from task_type..I have hardcoded..

Now the issue is i don't want to c the second dimension visible in the chart i.e. task_type..i required only fields..And i want tasktype fields in order:

1)Change request

2)Incident

3)U_request

4)Problem

Attached image for your reference..

Regards,

Bharat

Re: Pivot Chart

sunilkumarqv — Fri, 08 May 2015 06:06:49 GMT

Hi Bharat

you want task_type in order then create a calculated dimension

If(task_type='Change request',Dual('Change request',1),

If(task_type='Incident',Dual('Incident',2),

If(task_type='U_request',Dual('U_request',3),

If(task_type='Problem',Dual('Problem',4)))))

sort in ascending order

on Dimensions table click task_type and in label give a space without any a name

Re: Pivot Chart

CELAMBARASAN — Fri, 08 May 2015 06:10:36 GMT

For the task type dimension --> use Label as Space or ='' This will hide showing the label

And resize the column width to smaller one

Re: Pivot Chart

sasikanth — Fri, 08 May 2015 06:16:41 GMT

HI,

Try to give empty label to the task type ,

and sort the fileds before that

Re: Pivot Chart

bharatkishore — Fri, 08 May 2015 06:54:24 GMT

Hi Sunil..

Thanks for your reply..As per ur code i am getting other than 4 field values. So i don't want those fields and i want only 4 fields..Can u please help me on this

Re: Pivot Chart

sunilkumarqv — Fri, 08 May 2015 06:57:15 GMT

As you create calculated dimension it restrict only four fields .

share sample data ..

Re: Pivot Chart

ankitaag — Fri, 08 May 2015 07:31:25 GMT

Hi,

PFA the attached application.

Hope this helps!