Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
Highlighted
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.

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.