Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

dewako_data
New Contributor

FirstSortedValue mit variablen in Diagramm

hello everybody,

i try to find the last status with following syntax

=FirstSortedValue({<Anlage={'$(vAnlage)'}>} akt_status, -Akt_Ende,1) ,

but it is not running, please help me to find mistak in my syntax.

thanks lot

Tags (1)
5 Replies
MVP
MVP

Re: FirstSortedValue mit variablen in Diagramm

And your variable expands to .....?

Re: FirstSortedValue mit variablen in Diagramm

Hi,

what means "it is not running"?

Please post some sample data and your expected result.

regards

Marco

dewako_data
New Contributor

Re: FirstSortedValue  mit variablen in Diagramm

thank you so much, I have found the problem.

Highlighted

Re: FirstSortedValue mit variablen in Diagramm

you're welcome.

Can you please post the solution to your question as well?

thanks

regards

Marco

dewako_data
New Contributor

Re: FirstSortedValue  mit variablen in Diagramm

hello,

I want to get the last Status of all mashines, in the layout every mashine shoule get Status in colorful text diagramm. addionally there are also auto-reload function.

With firstsortevalue can i get the data.