topic Re: Sorting Problem in QlikView

Sorting Problem

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

My sorting is not working properly. But, I want to sort Top to Bottome like >70 and 50-70 and <50. Can you please have a look of attachment. If this is Correct then how to use Sorting Expressiobn.

Can anyone assist me, Please

My Calc Dim

=If(Sales >70, '>70',

If(Sales < 50, '<50',

'50-70'))

Expression

Sum(Sales)/Count( TOTAL Sales)

My Image is looking like this.

Re: Sorting Problem

Chanty4u — Wed, 10 Aug 2016 05:38:20 GMT

try this exp in sort tab exp

=Match(Sales >70,Sales >50-70,Sales > 50,'>70','>50-70','50')

Re: Sorting Problem

Chanty4u — Wed, 10 Aug 2016 05:42:21 GMT

Hi anil,

May be this?

Re: Sorting Problem

Anil_Babu_Samineni — Wed, 10 Aug 2016 05:50:13 GMT

Yes, In that how to exclude two values from Calc Dimension and Expression for Average.

Original is this, Assist me here for sorting and Calc Dimension, And let me know whether Expression is Correct or wrong?

Dimension

=Aggr(If(Avg( {<name -= {'Key Message Delivery','Sales Objective Category'}>} [2014 Score]) >70, '>70',

If(Avg({<name -= {'Key Message Delivery','Sales Objective Category'}>} [2014 Score]) < 50, '<50',

'50-70')),[2014 rep])

Expression

=Sum({<name = {"*"} - {"Key Message Delivery","Sales Objective Category"}>} [2014 Score])/

Count( TOTAL {<name = {"*"} - {"Key Message Delivery","Sales Objective Category"}>} [2014 Score])

Re: Sorting Problem

Chanty4u — Wed, 10 Aug 2016 05:55:33 GMT

where you are using the expression above mentioned?

Re: Sorting Problem

Anil_Babu_Samineni — Wed, 10 Aug 2016 06:03:27 GMT

Chanty What do you mean that?

I've written that expression in Expression tab to calculate the Avg in %

Re: Sorting Problem

Chanty4u — Wed, 10 Aug 2016 06:24:58 GMT

expression seem right

Re: Sorting Problem

qliktoview123 — Wed, 10 Aug 2016 06:42:20 GMT

Hey,

Please check this attachment.You will get the desired output.I have used dual function in the script for sorting.

Regards,

Atul

Re: Sorting Problem

Anil_Babu_Samineni — Wed, 10 Aug 2016 06:45:15 GMT

How about dimension?

If dimension is correct then how to write the sort expression for that expression depends on this dimension

Have a look this thread?

Re: Funnel Chart Dimension Problem

Re: Sorting Problem

qliktoview123 — Wed, 10 Aug 2016 06:49:09 GMT

You need to create a bucket and use dual function to sort it in backend.Please check the script.Once the dimension is available sort it by numerically ascending.

Re: Sorting Problem

Anil_Babu_Samineni — Wed, 10 Aug 2016 10:06:40 GMT

Hi,

PFA

For this, Help me.

I am expecting this for 2014 - Q1

Meantime, If i created one Bar chart then i need to show same thing on my application

Please Help me

Re: Sorting Problem

qliktoview123 — Wed, 10 Aug 2016 10:46:57 GMT

Hey,

I have just implented the bar chart as given below.Please check and let me know.

Regards,

Atul

Re: Sorting Problem

Anil_Babu_Samineni — Sun, 14 Aug 2016 11:20:54 GMT

Atul, Interesting.

Can you please work on here. In that, Sheet 12. Please help me.

Re: Sorting Problem

kaushiknsolanki — Sun, 14 Aug 2016 11:31:37 GMT

Hi,

Check out this.

Hope this is what you need.

Regards,

Kaushik Solanki

Re: Sorting Problem

Anil_Babu_Samineni — Sun, 14 Aug 2016 13:41:56 GMT

kaushik.solanki

The % Should Max 100% only. But, here 300% showing