topic Re: Sort dimensions manally in QlikView

Sort dimensions manally

Wed, 27 Feb 2013 10:01:59 GMT

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.

Re: Sort dimensions manally

Gysbert_Wassenaar — Wed, 27 Feb 2013 10:20:20 GMT

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.

Re: Sort dimensions manally

Wed, 27 Feb 2013 10:51:32 GMT

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

Re: Sort dimensions manally

Wed, 27 Feb 2013 11:23:38 GMT

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

Re: Sort dimensions manally

Wed, 27 Feb 2013 11:48:54 GMT

Before		After
Sales	100	Sales	100
COGS	200	COGS	200
Marketing	300	Amortization	300
Amortization	400	Marketing	400

Re: Sort dimensions manally

Wed, 27 Feb 2013 12:15:56 GMT

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

Re: Sort dimensions manally

Wed, 27 Feb 2013 12:28:41 GMT

Thank you Yaseen,

That work great!

I did it with match function =match(domain,'Sales','COGS','Marketing','Amortization')

Thank you again...

Re: Sort dimensions manally

Wed, 27 Feb 2013 12:57:49 GMT

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.