topic Re: Help needed in sorting expression for bar chart in QlikView

Help needed in sorting expression for bar chart

Wed, 28 Jan 2015 09:45:11 GMT

Hi All ,

i have a trend graph on a bar chart , were i am uploading 3 months of data . i would like to sort data on the basis of last uploaded month data.

for example : i am uploading data for october , november and decemeber . now i need to sort data on the basis of december data and i need to show respective november and october months data .

we have two dimenions

dottp1p2_enterprisesystem

monthdottp1p2

expression is

sum(days open)/ count(dottp1p2_enterprisesystem)

i use this sort expression

= count({<monthdottp1p2 = {"$(vmonth_current)"}>}dottp1p2_enterprisesystem)

the second image is the right one , for that i also need correspoding novemeber and october values .

i am getting the first image which is a wrong one .

hope it helps

Re: Help needed in sorting expression for bar chart

arsal_90 — Wed, 28 Jan 2015 12:54:01 GMT

can you share you qvw file. It's easy to work on your file and resolve your problem

Re: Help needed in sorting expression for bar chart

Wed, 28 Jan 2015 13:47:59 GMT

i am sorry , i cannot send the qlikview file .i would like to know , how to sort a expression in descending order by using a sort expression . i hope you dont get confused by sort a expression and sort expression

Re: Help needed in sorting expression for bar chart

beck_bakytbek — Wed, 28 Jan 2015 14:20:59 GMT

Hi Aditya,

Try this: go to tab Sort: and use: Numeric Value: Ascending or Descending

Hope this helps

Beck

Re: Help needed in sorting expression for bar chart

Anonymous — Thu, 29 Jan 2015 06:26:43 GMT

Hi Find attached solution and check the sort expression and its properties. In the place of hard coded value you can use your variable.

Hope this help.

Re: Help needed in sorting expression for bar chart

Anonymous — Thu, 29 Jan 2015 06:27:21 GMT

Let me know if you are looking for something else.

Re: Help needed in sorting expression for bar chart

Thu, 29 Jan 2015 06:38:04 GMT

Hi Balkumarchandel,

can you please , copy paste the logic . since i am using dekstop version . or else image of sort tab

Re: Help needed in sorting expression for bar chart

Anonymous — Thu, 29 Jan 2015 07:09:59 GMT

You need to use your sort expression in both the dimension and uncheck everything else.

Find below code your can first try to implement this example in separate document.

Load script :

load * inline [

Dim,Month,value

A,10,1

A,10,2

A,11,1

A,11,2

A,11,3

A,12,2

A,12,1

B,10,1

B,10,2

B,11,1

B,11,2

B,11,3

B,12,2

B,12,1

B,12,3

B,12,4

C,10,1

C,10,3

C,10,4

C,10,2

C,11,1

C,11,2

C,11,3

C,12,2

C,12,1

C,12,3

];

Re: Help needed in sorting expression for bar chart

Thu, 29 Jan 2015 07:36:16 GMT

but my expression here is = sum(days open)/ count(dottp1p2_enterprisesystem), which is not count .so how do i use sort expression ?

Re: Help needed in sorting expression for bar chart

Anonymous — Thu, 29 Jan 2015 08:11:51 GMT

count is not necessary .. Just use your expression in place of mine and check or uncheck the option as given in solution.

It will work.

Re: Help needed in sorting expression for bar chart

Thu, 29 Jan 2015 09:04:23 GMT

the expression i have is ,

sum(days open)/ count(dottp1p2_enterprisesystem)

and my dimensions are

dottp1p2_enterprisesystem

monthdottp1p2

the sort expression which i am using is

= count({<monthdottp1p2 = {"$(vmonth_current)"}>}dottp1p2_enterprisesystem)

but i am still getting the same values

Re: Help needed in sorting expression for bar chart

krishna20 — Thu, 29 Jan 2015 09:10:32 GMT

Hi,

Have you tried by keeping Y-Value at Descending?

Regards

Krishna

Re: Help needed in sorting expression for bar chart

Tue, 03 Feb 2015 04:41:43 GMT

any help is much appreciated

Re: Help needed in sorting expression for bar chart

krishna20 — Tue, 03 Feb 2015 05:56:32 GMT

Hi,

Please try this expression at your calculated dimension and let me know.Please edit this expression as for your second dimension also.Keep your expressions remains same and please, let me know that" (sum(days open)/ count(dottp1p2_enterprisesystem)) " is the only expression you are using? If yes, please replace your second dimension field in the below expression and try it.

=Aggr(Only({<dottp1p2_enterprisesystem={"(sum(days open)/ count(dottp1p2_enterprisesystem))"}>} dottp1p2_enterprisesystem), dottp1p2_enterprisesystem)

Regards

Krishna

Re: Help needed in sorting expression for bar chart

Tue, 03 Feb 2015 08:45:02 GMT

i am getting only one value 63 , i dont know what it is about . it is a wriong value i feel . i have two calculated dimenions you mentioned and i have expression measure as sum(days open)/ count(dottp1p2_enterprisesystem).
i am attaching you image too.

Re: Help needed in sorting expression for bar chart

Tue, 03 Feb 2015 11:21:35 GMT

any idea krishna , why it is giving this value . i am not not good with aggegrate function . can you tell me what you were trying to acheive with those calculated dimension ?

Re: Help needed in sorting expression for bar chart

krishna20 — Tue, 03 Feb 2015 11:54:01 GMT

Hi,

Please follow this link.

Bar chart Problem

Regards

Krishna