topic Re: Display the last data point in QlikView

Display the last data point

Tue, 08 Dec 2015 10:59:17 GMT

Hi all

Please how can I display the last data point of the following expression?

=sum({1<Sale_Date={">=$(=Max(Sale_Date)-12)<=$(=Max(Sale_Date))"},Product={'Product 1'}>} Sales)/

Count({1<Sale_Date={">=$(=Max(Sale_Date)-12)<=$(=Max(Sale_Date))"},Product={'Product 1'}>} Sales)

Regards

Re: Display the last data point

sunny_talwar — Tue, 08 Dec 2015 11:06:12 GMT

Not sure where you are trying to display it? Can you elaborate a little?

Re: Display the last data point

Anonymous — Tue, 08 Dec 2015 11:12:03 GMT

you are talking about max(Date) only, like this?

=sum({<Sale_Date={'$(=Max(Sale_Date))'},Product={'Product 1'}>} Sales)

Count({<Sale_Date={'$(=Max(Sale_Date))'},Product={'Product 1'}>} Sales)

It will give you max date values only

Re: Display the last data point

Anonymous — Tue, 08 Dec 2015 11:13:21 GMT

also make sure format of both Sale_Date and =Max(Sale_Date)) should be same

Re: Display the last data point

Tue, 08 Dec 2015 11:27:41 GMT

Hi Sunny T,

I am trying to achieve want was done this:

Display data point values on line chart

Re: Display data point values on line chart

JohnW 02-Sep-2011 12:20 (in response to aryehgros)

The reason the legend is displaying "Value" twice is that I stated one of the instructions VERY poorly. I'd said "Only display data values on the second expression." I really meant two things by this - on the first expression, do not display data values, and on the second expression, ONLY display data values. In other words, remove the checkmark next to "Line" for the second expression. I definitely should have written that differently.

The example is also using a variable, which I wouldn't bother with, and the example fails when you don't select any date. You can fix that by changing the expression to what I said to use, which in the context of this example would be this:

if(Date=max(total Date),Value)

Heh, nope. One minor error. It's displaying the nulls as '-'. I didn't expect that. So change it to a space, I guess:

if(Date=max(total Date),Value,' ')

That works. Thanks for building the example, Erika.

Edit: Oops, I didn't remove the variable like I suggested. I've updated the attachment to do so. Here's the new expression for Value:

sum({<Date={"<=$(=max(Date))"}>} Value)

Re: Display the last data point

Tue, 08 Dec 2015 11:30:32 GMT

Hi Balarj,

Your suggestion worked. The only issue is other data points are showing dash ("-") . Please how can I remove this?

Re: Display the last data point

Anonymous — Tue, 08 Dec 2015 11:32:46 GMT

Try suppress null values under dimension tab

Re: Display the last data point

Tue, 08 Dec 2015 11:37:01 GMT

Hi, suppressing null values did not work.

Re: Display the last data point

sunny_talwar — Tue, 08 Dec 2015 11:44:13 GMT

Would you be able to share a screenshot of what you are seeing right now?

Re: Display the last data point

Anonymous — Tue, 08 Dec 2015 11:48:41 GMT

Agree with Sunny, share a snapshot or sample, if possible?

Re: Display the last data point

Anonymous — Tue, 08 Dec 2015 11:49:48 GMT

How many dimension you are using?

You need to suppress for all the dimension one by one in Dimension tab...

Re: Display the last data point

Tue, 08 Dec 2015 11:52:05 GMT

One dimension.

Regards