Syntax help

datanibbler — Thu, 10 Apr 2014 12:00:57 GMT

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

Re: Syntax help

Thu, 10 Apr 2014 12:02:54 GMT

Please share demo app

regards

Darek

Re: Syntax help

datanibbler — Thu, 10 Apr 2014 12:30:07 GMT

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

topic Syntax help in QlikView

Syntax help

Re: Syntax help

Re: Syntax help