topic Re: Load max hour in QlikView

Load max hour

sanjujeeboy — Sat, 16 Nov 2024 02:01:22 GMT

i have a table like shown below: my requirement is in the chart i should get max date and max hour data ie 11/8/2019 and 3rd hour sales ie 108. how to write expression for this?

Country	Date	Hour	Sales
germany	11/6/2019	1	100
germany	11/6/2019	2	101
germany	11/6/2019	3	102
germany	11/7/2019	1	103
germany	11/7/2019	2	104
germany	11/7/2019	3	105
germany	11/8/2019	1	106
germany	11/8/2019	2	107
germany	11/8/2019	3	108

Re: Load max hour

sanjujeeboy — Wed, 06 Nov 2019 13:13:48 GMT

sorry the correct table is

Country	Date	Hour	Sales
germany	11/6/2019	1	100
germany	11/6/2019	2	101
germany	11/6/2019	3	102
germany	11/6/2019	4	103
germany	11/7/2019	1	103
germany	11/7/2019	2	104
germany	11/7/2019	3	105
germany	11/8/2019	1	106
germany	11/8/2019	2	107
germany	11/8/2019	3	108

Re: Load max hour

tresB — Wed, 06 Nov 2019 13:44:33 GMT

Try like:

Dim 1: Country

Exp 1: Date(Max(Date))

Exp 2: FirstSortedValue(Hour, -(Date*24+Hour))

Exp 3: FirstSortedValue(Sales, -(Date*24+Hour))

Re: Load max hour

sanjujeeboy — Wed, 06 Nov 2019 14:24:09 GMT

i want the output in straight table as

Country	Date	Hour	Sales
germany	11/8/2019	3	108

Re: Load max hour

tresB — Thu, 07 Nov 2019 06:33:09 GMT

Did you try the solution I proposed?

Re: Load max hour

sanjujeeboy — Thu, 07 Nov 2019 06:57:48 GMT

Hi,

the solution does work. Thanks

can we write a set expression for this?

Re: Load max hour

tresB — Thu, 07 Nov 2019 07:06:48 GMT

Set analysis is not something that should be used everywhere. Here you don't need that.

Please close the thread by giving 'like' and/or marking 'correct answer'.