Discussion board where members can get started with QlikView.
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:
Attached image for your reference..
you want task_type in order then create a calculated dimension
If(task_type='Change request',Dual('Change request',1),
sort in ascending order
on Dimensions table click task_type and in label give a space without any a name
For the task type dimension --> use Label as Space or ='' This will hide showing the label
And resize the column width to smaller one
Try to give empty label to the task type ,
and sort the fileds before that
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
As you create calculated dimension it restrict only four fields .
share sample data ..
PFA the attached application.
Hope this helps!