Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
segerchr
Contributor III
Contributor III

Set analysis/function inside

Hi,

this code should have the following function include. Is it possible ?

count({$<Urlaub={'x'}>+<verletzt = {'x'}>+<unentschuldigt={'x'}>+<Krank = {'x'}>}TerminID)

for example: count({$<Urlaub={'x'}>+<verletzt = {'x'}>+<unentschuldigt={'x'}>+<weekday(TerminDatum) = {'Mon'}>+<Krank = {'x'}>}TerminID)

Thanks...

BR CS

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Only field names on the left of a field modifier allowed, no functions.

Create an appropriate field for weekday in your script, then

count({$<Urlaub={'x'}>+<verletzt = {'x'}>+<unentschuldigt={'x'}>+<WeekDayField = {'Mon'}>+<Krank = {'x'}>}TerminID)

View solution in original post

3 Replies
swuehl
MVP
MVP

Only field names on the left of a field modifier allowed, no functions.

Create an appropriate field for weekday in your script, then

count({$<Urlaub={'x'}>+<verletzt = {'x'}>+<unentschuldigt={'x'}>+<WeekDayField = {'Mon'}>+<Krank = {'x'}>}TerminID)

segerchr
Contributor III
Contributor III
Author

Thanks for answering.

How can i combine OR and AND logic to the code ?

like this for example ?

count({$<WeekDayField = {'Mon'}>,<Urlaub={'x'}>+<verletzt = {'x'}>+<unentschuldigt={'x'}>++<Krank = {'x'}>}TerminID)


BR CS

swuehl
MVP
MVP

Maybe like

count(

{

<WeekDayField = {'Mon'}> * (<Urlaub={'x'}>+<verletzt = {'x'}>+<unentschuldigt={'x'}>+<Krank = {'x'}>)

}

TerminID)