topic Re: Latest values only in ListBox in QlikView

Latest values only in ListBox

Anonymous — Thu, 04 Aug 2016 06:47:52 GMT

Hi all,

I am trying to show a list of the values from one column for the 'latest set' of data - as defined by a second column.

Here is some sample data :

DateFld	SalesValue	BG
2016-06-08	0	G
2016-06-09	1	A
2016-06-10	2	A
2016-06-11	4	B
2016-06-12	8	B
2016-07-17	16	C
2016-07-17	32	D
2016-07-17	64	E
2016-07-20	128	A
2016-07-20	256	B
2016-07-20	512	E

What I need to show are the values from column 'BG' which correspond to the latest value for column DateFld.

I've currently got a List Box that shows all values of BG, but it is showing 'all' values.

I can process only the 'latest data' in a chart control by using set analysis expression - such as: {$<DateFld = {"$(=max(DateFld))"}>}

But if I use a chart control I can't see a way of only listing the dimension value (in my case values from column BG) - it seems that I always need to also show the results of an expression.

I can't seem to find an equivalent way of doing this in a list box. May be I need to use a chart control but make it appear to th euser just like a list - that they can then select from.

All ideas gratefully received.

Cheers,

Dave

Re: Latest values only in ListBox

antoniotiman — Thu, 04 Aug 2016 07:59:51 GMT

Try Expression in List Box

=If(DateFld = Max(TOTAL DateFld),BG)

Re: Latest values only in ListBox

Thu, 04 Aug 2016 08:22:00 GMT

Hi David

You can try this expression for list box

=if(DateFld=max( total DateFld),BG,null())

Regards

Ahmed

Re: Latest values only in ListBox

rajuamet — Thu, 04 Aug 2016 08:25:21 GMT

Hi Dave,

PFA

Re: Latest values only in ListBox

Anonymous — Thu, 04 Aug 2016 09:00:57 GMT

Hi Antonio,

Brilliant! Thanks very much.

Cheers,

Dave

Re: Latest values only in ListBox

Anonymous — Thu, 04 Aug 2016 09:01:21 GMT

Hi Mohd,

Thanks very much.

Cheers,

Dave

Re: Latest values only in ListBox

Thu, 04 Aug 2016 09:16:08 GMT

Hi David,

I will explain you by step wise:

Step:1 --- Load data into Edit Script

Step : 2 --- Reload Data

Step: 3 --- Create list box--> Properties -> You can see General Tab --> Field -> You can select Expression --> You can write below Expression.

Step: 4-- =if(DateFld=max( total DateFld),BG,null())

Thanks

Nandu