topic Re: Sorting graph - sort order in QlikView

Sorting graph - sort order

Tue, 12 Aug 2014 07:39:33 GMT

Hi,

I have a problem by sorting my graphs.

I have this graph as is shows now - It shows data from 2014-1-10 to 2014-3-21.

However i have data untill now so i want the graph to show example 2014-07-10 to 2014-08-12

So it only shows the newest dates. How can i do so? I have tried to sort my data by date and make a RowNo()

but when i try to sort it reverse the graph so it shows from 2014-08-12 to 2014-07-10 - So its the wrong way.

Can anyone help?

Anonymous — Tue, 12 Aug 2014 07:41:51 GMT

Create a variable for the dates and use inside the set analysis

Tue, 12 Aug 2014 07:53:27 GMT

How would you do that if the expression was like this? =sum({<Flag={1}>}Price)

Anonymous — Tue, 12 Aug 2014 07:57:27 GMT

Try this

=sum({<Date>={$(vDate)},Flag={1}>}>}Price)

Tue, 12 Aug 2014 08:24:21 GMT

but it should not be a date but greather than.

Wed, 13 Aug 2014 10:28:17 GMT

solved in this post: