topic Re: Result in QlikView

Result

deepakqlikview_123 — Fri, 02 May 2014 09:44:10 GMT

Hello all,

Please find attachment.

Below is a formula that I have used while calculating % absent employee.

=num(

(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' )

Now as per requirement if absent employee =100% then there is need to show Null or some image

Can u please suggest how to proceed.

Thanks,

its_anandrjs — Fri, 02 May 2014 09:46:21 GMT

Try like

= If( (num(

(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' ) ) ='100%' ,Null(),

(num(

(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' ) ))

its_anandrjs — Fri, 02 May 2014 09:59:46 GMT

Or you can write

= If( (num(

(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' ) ) ='100%' ,'qmem://<bundled>/BuiltIn/smiley1_g.png',

(num(

(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' ) ))

deepakqlikview_123 — Fri, 02 May 2014 10:24:33 GMT

Hi anand,

Smiles are not working here.

Thanks

its_anandrjs — Fri, 02 May 2014 10:34:58 GMT

After adding above expression change your expression as image and image formatting keep Aspect.

See the attached snap

deepakqlikview_123 — Fri, 02 May 2014 10:41:05 GMT

Thanks anand,

It worked.