topic Re: Problem with num function in QlikView

Problem with num function

Anonymous — Thu, 09 Apr 2015 07:15:15 GMT

Hi,

i developed dash board plese find following attachment.

In that when i select the 26th feb 2015 selections it gives exponential values but i have to display numeric values.

Please help me.

Thanks,

Anonymous — Thu, 09 Apr 2015 07:20:01 GMT

can you post your sample data !! i am using PE

Anonymous — Thu, 09 Apr 2015 07:22:42 GMT

Add some more ### because which you have given are not enough to show all the numbers .

='Call Center' & chr(13) &

if(MTD='Day',num(sum({$<Date={'$(=max(Date))'},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'#,##########')

,num(sum({$<Date={'$(=v_Previous_Date_2)'},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'###,#########')

)

Use this

Thanks

BKC

Anonymous — Thu, 09 Apr 2015 07:23:31 GMT

what format should be shown?

if you use '0.000' instead of '#,###' I get a number. correct format?

PrashantSangle — Thu, 09 Apr 2015 07:26:12 GMT

Hi,

Try below changes in num()

try below,

num(yourexpression,'##,#00')

instead of ## in end try with 00

Regards

Anonymous — Thu, 09 Apr 2015 07:26:51 GMT

Hi balkumar,

Thanks for your help its help full for me.

Thanks,

avinashelite — Thu, 09 Apr 2015 07:28:42 GMT

Mistake is with the num format you have given try like this:

if(MTD='Day',num(sum({$<Date={"$(=max(Date))"},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'###,###')

,num(sum({$<Date={"$'(v_Previous_Date_2)'"},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'###,###')

)

format: Num(expression,'###,###')