topic Re: show only the last value in a graphic in QlikView

show only the last value in a graphic

Mon, 13 Jan 2014 13:50:57 GMT

is it possible to show only the last value (written in the Graphic):

Thanks....

Re: show only the last value in a graphic

datanibbler — Mon, 13 Jan 2014 13:56:32 GMT

Hi Ingo,

so you want this whole x-axis (1990 to 2004), but only the value for 2004 visible?

How about editing the "background colour" of the chart (formula_properties, click on the "+" sign) to be

- blue for the last dimension value

- white otherwise

HTH

Best regards,

DataNibbler

Re: show only the last value in a graphic

Nicole-Smith — Mon, 13 Jan 2014 14:07:23 GMT

For example, if your dimension is Year and your expression is sum(Sales), you need to set up a second expression that looks like the following:

if(Year=$(=max(Year)), sum(Sales), '')

An example is also attached.

Re: show only the last value in a graphic

Mon, 13 Jan 2014 14:17:05 GMT

Hey,

thank you for the quick response.

The line should be visible, but only the last value should be shown in the graphic:

Re: show only the last value in a graphic

Mon, 13 Jan 2014 14:22:29 GMT

Hey Nicole,

its working....thank you very much for the correct solution.....great!!

Best regards...

Re: show only the last value in a graphic

Nicole-Smith — Mon, 13 Jan 2014 14:26:11 GMT

I'm glad it works

Re: Re: show only the last value in a graphic

Tue, 14 Jan 2014 09:57:22 GMT

Hi Nicole,

sorry, one more question. In the following case it doesnt work (second Graphic). Do you have any idea? Thank you in advance.

Best regards...

Re: show only the last value in a graphic

Anonymous — Tue, 14 Jan 2014 10:44:59 GMT

Hi Ingo,

It is a because of a problem with your Date format.

try this:

if(num(Datum) = $(=num(max(Datum))), Umsatz_Auto, '')

Re: Re: show only the last value in a graphic

Tue, 14 Jan 2014 12:04:29 GMT

Hi,

thank you very much . In the above example your solution is working. Do have any idea for the following

one?Is the date Format, the Variable or the group by period the Problem?

Re: Re: show only the last value in a graphic

Anonymous — Tue, 14 Jan 2014 13:19:21 GMT

Hi,

I think you'd better change your model to create a separate calendar from your model, like this:

FACT:
LOAD
     Anliegen_Nr,
     [Vers. Person],
     Eingangskanal,
     Anliegen_Status,
     A_Eröffnungsdatum,
     A_Erledigungsdatum,
     A_Abschlussdatum,
     ANL_versch_Flag,
     ANL_versch_Anz,
     ANL_erl_min
FROM
C:\Users\p14890\Desktop\test.xls
(biff, embedded labels, table is [Sheet1$]);

CALENDAR:
LOAD DISTINCT
A_Eröffnungsdatum      as Date,
Month(Date(A_Eröffnungsdatum))    as Mois,
Year(Date(A_Eröffnungsdatum))    as Annee,
'Q'&Ceil(num(Month(Date(A_Eröffnungsdatum)))/3) as Trimestre
RESIDENT
FACT:
;

Then you can work easily on the year, month or date as you want.

Re: show only the last value in a graphic

Jaswinder — Mon, 19 Aug 2019 07:16:56 GMT

Dear,

Your provided solution is really helpful.

But i need to Accumulate expression and show result on last financial year month entry

Data Accumulate in Expression and need to shown at last Mar month

If you can help