topic Automatic sorting in Straight or Pivot table in QlikView

Automatic sorting in Straight or Pivot table

hopkinsc — Mon, 04 Oct 2010 16:30:11 GMT

Hi,

I need help!!

Is there a way of stopping the automatic sorting when i select a value within a straight or pivot table?

I have a Straight table with transaction header details,

i.e.

RETAILER NAME, TILL NO, TRANSACTION ID, EMPLOYEE NAME, DATE, TIME, SALES AMOUNT.

As the user scrolls through the table to look for a transaction, when they find it and select it, another straight table appears showing the products bought, price, qty etc.

The problem i have is that as soon as the user selects the transaction they wish to look at (in the header), all other header details dissappear and the one selected moves to the top. If the user then wants to look at the next transaction, they have to start back at the top and scroll back down.

I am wondering if there is a sort expression i could use to stop it from changing so that the user could select one after the other without having to scroll through the list again.

Can anyone help please ?

Automatic sorting in Straight or Pivot table

syed_muzammil — Mon, 04 Oct 2010 16:40:50 GMT

Hi,

Check the Preserve scroll position in chart Properties--> Layout.

Regards,

Syed.

Automatic sorting in Straight or Pivot table

Tue, 05 Oct 2010 07:01:33 GMT

Hi,

Here you are a possible solution, check out the option show all the values on the Dimension and the Order sentence, It will keep all the records and you never lost the position.

I hope it helps you.

Regards.

Automatic sorting in Straight or Pivot table

hopkinsc — Tue, 05 Oct 2010 09:54:02 GMT

Hi Miguel,

Can you explain what the sort expression in your example means please?

I need to tick 'Show All Values' on my TRANSACTION ID dimension, but am unsure what to put into my sort expression as i have around 7 different dimensions.

Automatic sorting in Straight or Pivot table

Thu, 07 Oct 2010 07:06:10 GMT

hi,

the sort expresion "=sum({<Data=>} Value)" means that order of the data omits any selection on the field Data and keeps the order based in the Sum(Value) allways.

Regards.

Automatic sorting in Straight or Pivot table

Thu, 07 Oct 2010 18:34:15 GMT

Perhaps you can try

Right Click on Pivot Table properties -> goto general Tab -> check the "Detached" checkbox

Do this for those table you want to make it static.

Hope this help, or hope i didn't misunderstood your situation

Re: Automatic sorting in Straight or Pivot table

Wed, 21 Dec 2016 17:26:59 GMT

Thanks man, worked for me.