Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
bharatkishore
Contributor III

Pivot Chart

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

6 Replies
Highlighted
sunilkumarqv
Valued Contributor II

Re: Pivot Chart

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

Highlighted

Re: Pivot Chart

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

And resize the column width to smaller one

Highlighted
sasikanth
Valued Contributor III

Re: Pivot Chart

HI,

Try to give empty label to the task type ,

and sort the fileds before that

Highlighted
bharatkishore
Contributor III

Re: Pivot Chart

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

Highlighted
sunilkumarqv
Valued Contributor II

Re: Pivot Chart

As you create calculated dimension it restrict only four fields .

share sample data ..

Highlighted
Partner
Partner

Re: Pivot Chart

Hi,

PFA the attached application.

Hope this helps!