Sort dimensions manally

[#1]

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.

[Gysbert_Wassenaar]

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.

[#3]

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

[#4]

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

[#5]

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

[#6 · Accepted solution]

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

[#7]

Thank you Yaseen,

That work great!

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

Thank you again...

[#8]

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.