Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I would like to sort one dimension manyally,
In sort part of chat properties have some options, but i would be able to drop and drag in pivot chart fields like in Pivot table in excel (If it is posible 🙂 )
Are there some easy solution or should i try with multiple if in Exprecion part?
Thank you and sorry for maybe to straightforward questions.
Hi Vik,
Go to chart properties Sort, check on expression and write the below expression.
IF(Domain ='Sales',1,
IF(Domain ='COGS',2,
IF(Domain ='Marketing',3,
IF(Domain ='Amortization',4))))
After this check Numeric Value as Asc
Regards,
Yaseen
You can move dimensions around in the pivot chart by dragging them left or right or to the top. But you can drag them from a list of fields in and out of a pivot table like in excel. If you have QV11 you can use conditional display to show/hide dimensions. In combination with a listbox with field names where you can select fields it's possible to create a dynamic pivot chart showing only the fields you select in the listbox. The What's New in Qlikview 11 document has an example of that on the Reports tab.
Gysbert,
Thank you for reply.
I want to ask about different fields in dimension.
I have one pivot table like this vertically:
Dimension is KTO:
Amortization
Sales
COGS
I would like to drag Sales up and then Cogs, and then Amortization:
Sales
COGS
Amortization
Maybe this is basics, so sorry about that.
There are some sort options but i can not use them.
Ivan
Sorry for the bad example,
I don't want to anything ascending or descending, neither numbers nor texts.
So new example will be: I would my fields to look like that.
Sales
COGS
Amortization
Marketing
Before | After | ||
Sales | 100 | Sales | 100 |
COGS | 200 | COGS | 200 |
Marketing | 300 | Amortization | 300 |
Amortization | 400 | Marketing | 400 |
Hi Vik,
Go to chart properties Sort, check on expression and write the below expression.
IF(Domain ='Sales',1,
IF(Domain ='COGS',2,
IF(Domain ='Marketing',3,
IF(Domain ='Amortization',4))))
After this check Numeric Value as Asc
Regards,
Yaseen
Thank you Yaseen,
That work great!
I did it with match function =match(domain,'Sales','COGS','Marketing','Amortization')
Thank you again...
Hi Vik,
You also have one more solution in QlikView.
Try Loading the values of this column in an inline table as seen below, before it loads from normal table:
Load * Inline
[ Domain
Sales
COGS
Marketing
Amortization
]
And then drop this table at the end. In the chart column properties for Sort , you can select the Load Order option.