Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

if statement into set analysis

i am using this if statement in straight table expression please help me to convert this in set analysis

=if(SHIFTSTARTTIME<IN1 and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')<'00:10:00','Yes','No')

5 Replies
sergey_maka8
Valued Contributor

Re: if statement into set analysis

Hi

In your case I would add if(SHIFTSTARTTIME<IN1 and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')<'00:10:00','Yes','No') AS YourDimension in the load script

and then just use it as dimension.

I don't see how you can convert it to set analysis, just because you don't use aggregation functions like sum, count etc. in this expression

chauhans85
Esteemed Contributor

Re: if statement into set analysis


Only({<SHIFTSTARTTIME={"<$(=IN1)"}, IN1-SHIFT={'<00:10:00'}>} 'Yes') +

same this expression only change 'Yes'  to 'No'

hope this helps

Not applicable

Re: if statement into set analysis

if

i want to show if (shiftstarttime<in1, count(employee)) in set

Not applicable

Re: if statement into set analysis

if

i want to show if (shiftstarttime<in1, count(employee)) in set

how will i show it

chauhans85
Esteemed Contributor

Re: if statement into set analysis

count({<shiftstarttime={<$(=only(in1))}>employee)

Community Browser