Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

segerchr
New Contributor II

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
MVP
MVP

Re: Set analysis/function inside

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)

3 Replies
MVP
MVP

Re: Set analysis/function inside

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
New Contributor II

Re: Set analysis/function inside

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

MVP
MVP

Re: Set analysis/function inside

Maybe like

count(

{

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

}

TerminID)