topic Re: Sorting Issue in QlikView

Sorting Issue

Tue, 15 Nov 2016 06:03:18 GMT

Hi ,

I have a straight table with account as dimensions and many metrics. I have a column having Volume-1 and Volume-2 as metrics. Volume-1 and Volume-2 are conditionally enabled and disabled based on selection in list box.

Below i have a chart with time and account as dimension and same Volume-1 and Volume-2 as metrics. Volume-1 and Volume-2 are conditionally enabled and disabled based on selection in list box.

I try to sort the upper straight table with volume by keeping this expression in priority in sort TAB.

I try to sort the lower chart with volume as expression(descending)

Thanks

Khushboo

Re: Sorting Issue

shraddha_g — Tue, 15 Nov 2016 06:05:57 GMT

what is the issue?

Re: Sorting Issue

Tue, 15 Nov 2016 06:09:21 GMT

Different sorting in upper and lower graph and grids.

Re: Sorting Issue

Chanty4u — Tue, 15 Nov 2016 06:13:45 GMT

did u try with

sort tab -> expression

=Match(FieldName.,'A','B'........)

Re: Sorting Issue

shraddha_g — Tue, 15 Nov 2016 06:14:43 GMT

In second chart you have 2 dimension time and account and in 1st one you have only account.

Right?

In second chart sorting will also consider time along with account while sorting.

Re: Sorting Issue

Anonymous — Tue, 15 Nov 2016 07:58:38 GMT

Since account is the common field, on your second chart try moving/promoting account to the first position.

Then on the sort tab make sure the account field has Y value desc and reset the time field back to default sort