topic Re: Fix the sort order in a straight table in QlikView

Fix the sort order in a straight table

Tue, 02 Apr 2013 06:11:10 GMT

Hi,

I have a straight table, which has so many expressions.

I want to sort the table always with one expression value.

How can i do that using macro or any other method?

i have prev and next button implemented. Clicking that some expressions will be shown and others will be hidden.

so i want to sort the table based on a single expression always, even if it is hidden also.

If a user has changed the sort by clicking some column, then click on next button should retain the sort order back to the previous sort order.

How can we do that?

Re: Fix the sort order in a straight table

sushil353 — Tue, 02 Apr 2013 06:14:03 GMT

hi,

have u tried this:

1.goto sort tab

2. click on each dimension and expression and sort them by expression. put your expression in definition box...

if this will not work then please post your sample app and describe your issue in detail.

HTh

Sushil

Re: Fix the sort order in a straight table

Tue, 02 Apr 2013 06:19:46 GMT

Hi sushil,

I want to sort the table on clicking a button.

It should sort based on a single expression written in the chart always.

How to achieve that?

I used the below macro

Sub SortChart Set ch = ActiveDocument.GetSheetObject("CH01") ch.SortBy 8 '' this line specifies the expression to sort by Set p = ch.GetProperties Set dims = p.Dimensions '' Dimensions start by 0 '' 0 = Disable sort '' 1 = Sort ascending '' -1 = Sort descending i = dims.Item(0).SortCriteria.SortByNumeric If i = 1 Then dims.Item(0).SortCriteria.SortByNumeric = -1 Else dims.Item(0).SortCriteria.SortByNumeric = 1 End If ch.SetProperties p End Sub

It works fine, but here i have given the sortby "8" th expression, but when i click the next button, it will hide first 10 expressions and shows the next 10 expressions. so that sort order changes for the 2nd "8" expression enabled.

But i want the sort to remain for the 1st "8th" expression in the table.

Re: Fix the sort order in a straight table

kaushiknsolanki — Tue, 02 Apr 2013 06:25:30 GMT

Hi,

Why do you want to use the macro, when same can be done by what Sushil has suggested.

The reason for not using macro is, they may and may not work on browser and can slow down your application if not used properly.

Regards,

Kaushik Solanki

Re: Fix the sort order in a straight table

sushil353 — Tue, 02 Apr 2013 06:32:18 GMT

Hi,

If it is mendetory to have button to sort your table. then try this.

1. create a variable: say--- vsort

2. in the sort tab for expression sort put some condition like: if(vsort=1,expression)

here expression is your expression on which you want to sort the table

3. creat a button and set the variable value 1 on click.

It is better to avoid macros..

HTH

Sushil

Re: Fix the sort order in a straight table

Tue, 02 Apr 2013 06:33:01 GMT

The problem is,

The user can sort the columns manually by double clicking columns.

Then the sort order will change, but i want the sort order should come back to previous state by clicking the "Next" button in my application qvw file.

Re: Fix the sort order in a straight table

Tue, 02 Apr 2013 06:40:23 GMT

Sushil,

I tried the method, it is not working in my file.

I change the sort order, by double clicking some other expression.

And i applied the sort expression for the dimension to sort in the table.

It is not sorting the dimension based on the expression value.

Re: Fix the sort order in a straight table

sushil353 — Tue, 02 Apr 2013 06:44:48 GMT

Please post the sample app.

Re: Fix the sort order in a straight table

Tue, 02 Apr 2013 06:45:43 GMT

It has the client data, so sorry i cannot post the file

Re: Fix the sort order in a straight table

Tue, 02 Apr 2013 06:46:47 GMT

Can you tell me how we can modify the above macro, so that we can achieve this on clicking the button.

Re: Fix the sort order in a straight table

kaushiknsolanki — Tue, 02 Apr 2013 06:53:15 GMT

Hi,

If you dont want user to double click and change the sort then you do following setting.

Go to Sort tab -> Uncheck the "Allow interactive sort".

This will not allow user to change the sort.

Regards,

Kaushik Solanki

Re: Fix the sort order in a straight table

sushil353 — Tue, 02 Apr 2013 06:54:32 GMT

Problem with macro is: when it is activated it takes the current 8th expression from the chart...

when you are hiding the expressions then it gives wrong sorting...

the only trick which is coming to my mind is...

lets say you are having exp1 on which you need to sort your table...

take exp1 2 times in your table... now you will get two colomns with same expression that is exp1.

now make the Text color white for one of the column and header lable a space.. so that one column should not be visible..

now use that column no in your macro....

HTH

Sushil

Re: Fix the sort order in a straight table

Tue, 02 Apr 2013 06:59:11 GMT

But I have around 120 expressions in a table, it keeps changing on clicking the next button,

so i cannot use that expression multiple times in the table.

I want to restrict the sort to use only the 1st "8th" expression as the sort order,

but in the above macro, it changes for the current "8th" expression.

And client requirement is, they should be able to sort every column manually, so i cannot restrict them from sorting manually. but i want the sort to retain even if they sort it manually on clicking a button.

Re: Fix the sort order in a straight table

sushil353 — Tue, 02 Apr 2013 07:02:07 GMT

Dear Surya,

Make some dummy data and create a sample app...

without seeing your application it is difficult to give exact solution...

HTh

Sushil

Re: Fix the sort order in a straight table

Tue, 02 Apr 2013 07:07:34 GMT

Sushil,

There are so many combinations for getting the data.
To prepare data itself it will take time and we are working now for a deliverable today.

so not able to prepare sample data now.

Re: Fix the sort order in a straight table

sushil353 — Tue, 02 Apr 2013 07:08:44 GMT

any screenshots.. to explain your required functionality?