Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Syntax help

Hi,

how to write this:

- I have a chart (combochart) displaying (when first opened) the average of the duration of sickness_phases per day, the dimension is
  from a qvs file and based on a field %Datum (that exists also in this new data_table, plus an identical field Date_sick)
  => When the user selects one specific day (one value of %Datum), the chart changes:
  => it now displays the details (the IDs of the emps who were sick on that day and their cumulative sickness_duration,
        the dimension is now another one, namely the ID
  => in that case, the date (the first dimension) should turn white, otherwise it should be black

<=> How to write that? I have tested with COUNT(Getfieldselections(%Datum)) and COUNT(Getfieldselections(Date_sick)),

    but both don't seem to work.

Thanks a lot!

Best regards,

DataNibbler

2 Replies
Not applicable

Please share demo app

regards

Darek

datanibbler
Champion
Champion
Author

I just wrote another post which is quite identical to this one, just a bit more encompassing, so I'll close this (well, I'll mark it as "probably solved" which is the nearest to closing a thread I can do here).

Thanks a lot anyway!

Best regards,

DataNibbler