topic Re: Sorting Issue in QlikView

Sorting Issue

Tue, 24 Feb 2015 23:00:53 GMT

Hello,

I have an expression in Straight table which is appended with some text value

Example: ' A :' & Sum(Sales) & chr(10) & Sales%

I am trying to sort my Straight table based on the Sales % value from the above mentioned expression. But the sort by expression is disabled for this expression. So I need to use dual or some logic to sort my expression.

Thankyou for your help

Re: Sorting Issue

MK_QSL — Tue, 24 Feb 2015 23:17:04 GMT

Dual(' A :' & Sum(Sales) & chr(10) & Sales%,Sales%)

Re: Sorting Issue

maxgro — Tue, 24 Feb 2015 23:20:16 GMT

maybe (in sort tab) you can promote a dimension at the first position

and sort that dimension by expression sum(Sales)

Re: Sorting Issue

Tue, 24 Feb 2015 23:38:42 GMT

Hi Kailash,

Sort expression is always disabled for expression in straight table. You have to sort the dimensions based on some expression.

Hope this help,

Anosh

Re: Sorting Issue

mukesh24 — Wed, 25 Feb 2015 07:38:57 GMT

Hi,

u can sort u r dimension base on u r expression.

Re: Sorting Issue

Wed, 25 Feb 2015 15:41:35 GMT

Hello Manish,

Thank you for your response, When I use Dual(' A :' & Sum(Sales) & chr(10) & Sales%,Sales%)....I am just getting % value. Text and Sum(Sales) is not showing up in expression.

Re: Sorting Issue

MK_QSL — Wed, 25 Feb 2015 15:56:15 GMT

Go to presentation tab

Tick Wrap Cell Text and Set

Cell Height 2 or 3 lines

Re: Sorting Issue

Wed, 25 Feb 2015 22:05:36 GMT

Hello Manish,

My actual Expression is

' A :' & Sum(Sales) & chr(10) & Sales% & "B : ' & Sum(Quantity)

I have 3 parameters to pass into dual . two sums and single %.

Dual works fine with single Sum and %.Where your solution is exactly correct. But I have two sums appended.

Thanks

Re: Sorting Issue

MK_QSL — Wed, 25 Feb 2015 23:39:29 GMT

What is the base criteria for sorting?...i.e. sales or qty?...if possible. .provide sample file

Re: Sorting Issue

jagan — Thu, 26 Feb 2015 03:13:22 GMT

Hi Kailash,

In sort tab select this expression and select Expression option and give the percentage expression in the text box.

Also promote this expression to the top.

Regards,

Jagan.

Re: Sorting Issue

avinashelite — Thu, 26 Feb 2015 04:47:25 GMT

Hi Kailash,

Go to sort tab and select expression option > paste your sorting expression i.e. sales% here this should work!!

Re: Sorting Issue

Thu, 26 Feb 2015 17:54:18 GMT

Sales % is the criteria for Sorting.

Re: Sorting Issue

Thu, 26 Feb 2015 17:55:11 GMT

In Sort Tab, Sort by expression tab ll be disabled. So cant do that.

Re: Sorting Issue

Thu, 26 Feb 2015 18:12:45 GMT

In Sort Tab, Sort by expression tab ll be disabled. So cant do that.