topic Re: Formula in QlikView

Formula

deepakqlikview_123 — Wed, 30 Apr 2014 12:04:01 GMT

Hello Team,

want to show percentage for difference between Man on role and presnent as per DeptFlag FAB

For that pupose I am using below formula.But it seems it is not working.

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

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

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

Can you please suggest what corrections are required in this.

Thanks,

Deepak

MK_QSL — Wed, 30 Apr 2014 12:07:06 GMT

Try this...

=num(

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

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

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

its_anandrjs — Wed, 30 Apr 2014 12:10:48 GMT

Write like below

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

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

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

Use brackets for the Numerator or denomenator sepearate

and let me know

deepakqlikview_123 — Wed, 30 Apr 2014 12:14:09 GMT

Hi Anand/Manish,

It is working fine now.

Can you please tell me while formatting what kind of parameters we need to consider.

Thanks