topic Re: Re: make a graph show latest dates values in QlikView

make a graph show latest dates values

Tue, 15 Jul 2014 11:06:06 GMT

Hi,

I have a graph with data from the 1st january 2014 until now. But when the graph is shown it can only show maybe 15 dates.

The graph show the dates from the 1st jan - How can i do so it shows the data from the newest dates? so it shows july instead?

Re: make a graph show latest dates values

tresB — Tue, 15 Jul 2014 11:28:40 GMT

In your chart expression use set analysis something like:

=Sum({<Date={">$(=Max(Date)-15) <=$(=Max(Date))"}>}Amt)

Re: make a graph show latest dates values

Tue, 15 Jul 2014 11:44:26 GMT

can it be done without set analysis?

Re: make a graph show latest dates values

Tue, 15 Jul 2014 11:45:26 GMT

Because your set filters it down to only 15 dates. I dont want it to be filtered. I just want to see the latest dates instead of the first dates.

Re: make a graph show latest dates values

tresB — Tue, 15 Jul 2014 11:52:12 GMT

What is your logic to decide a date to be one of the latest ?

Re: make a graph show latest dates values

jonathandienst — Tue, 15 Jul 2014 11:52:45 GMT

So you would like to scroll it to the most recent dates? I don't think that is possible. Your options are to filter the data, aggregate it so that there are fewer data points, sort in reverse order, or allow the user to manually scroll to the end.

With a a filter like tresesco's suggestion, you can select on a date list box to see the 15 days prior to the selected date (or the maximum date in your model if nothing is selected).

HTH

Jonathan

Re: make a graph show latest dates values

Tue, 15 Jul 2014 11:54:58 GMT

last or first sorted? Due to the fact i dont want to see old data when i first see my grtaph. If i wanna see old data i want to filter it instead.

Re: make a graph show latest dates values

Tue, 15 Jul 2014 11:55:18 GMT

Let me show you a picture.

Re: Re: make a graph show latest dates values

Tue, 15 Jul 2014 12:00:43 GMT

This is how it is now:

This is how i want it

Re: make a graph show latest dates values

tresB — Tue, 15 Jul 2014 12:01:07 GMT

You may allow user to choose if they want to see old data. By default it would be the latest dates. For that you can use two expressions (one as shown above, another without that set filter) and enable them as per user selection. Allow users to select a flag in inputbox that get stored in a variable.

Re: make a graph show latest dates values

tresB — Tue, 15 Jul 2014 12:02:21 GMT

Sort on Date -> Descending order and enable scroll in the presentaion tab.

Re: make a graph show latest dates values

Tue, 15 Jul 2014 12:04:25 GMT

scroll is not an option. Looks bad!

Sorting will make the dates turn wrong.

But i guess its not possible - I would have to make set analysis that dont disregard the selections

Re: make a graph show latest dates values

Tue, 15 Jul 2014 12:57:20 GMT

perhaps something like this:

Try to sort with formular:

firstsortedvalue(Amt, -[YourReloadDate])

The"-" before your reload timestamp kind of makes the opposite. So Lastsortedvalue ISO firstsortedvalue...

Maybe you can work around this one?!

Why is sorting turning your dates wrong???

Anthony

Re: make a graph show latest dates values

Tue, 12 Aug 2014 08:49:29 GMT

Hi thank you for this.

But when i type this set analysis in - Then i cannot use my filter . Eg months. Because then it will only show 15 days in that month.

How do i make it account for my selections?