topic Re: firstsorted value in set analysis in QlikView

firstsorted value in set analysis

kris_vliegen — Tue, 17 Jun 2014 11:11:54 GMT

Hello,

I try to use the first-sorted value in a gauge-chart.

I'm making a dashboard for fuelstations.

I would like to create a gauge-chart by petroltype.

But not every fuelstation has the same petrol-type's.

In a textbox I can show the Artikel by =FirstSortedValue(ARTNKey,ARTNID,3)

In the gauge-chart I would like to do something like this

=sum( { $ < CalYear = {$(vCurrentYear)}, [~Type] ={'T'}, ARTNKey={"=FirstSortedValue(ARTNKey,ARTNID,1)"} >}Quantity) /

sum( { $ < CalYear = {$(vPrevYear)}, [~Type] ={'T'}, ARTNKey={"=FirstSortedValue(ARTNKey,ARTNID,1)"} >}Quantity)

But this is not working...

Who canhelp me?

Regards,

Kris

Gysbert_Wassenaar — Tue, 17 Jun 2014 11:14:09 GMT

Maybe like this:

=sum( { $ < CalYear = {$(vCurrentYear)}, [~Type] ={'T'}, ARTNKey={"$(=FirstSortedValue(ARTNKey,ARTNID,1))"} >}Quantity) /

sum( { $ < CalYear = {$(vPrevYear)}, [~Type] ={'T'}, ARTNKey={"$(=FirstSortedValue(ARTNKey,ARTNID,1))"} >}Quantity)

Tue, 17 Jun 2014 11:14:35 GMT

try,

ARTNKey = {'$(=(firstsortedvalue(ARTNKey,ARTNID,1)'}

regards,

kris_vliegen — Tue, 17 Jun 2014 11:20:32 GMT

Thanks Magdalena,

This is working ARTNKey = {'$(=(firstsortedvalue(ARTNKey,ARTNID,1)))'}

Regards,

Kris