topic Re: Numerical Values in chart in QlikView

Numerical Values in chart

Tue, 12 May 2015 09:43:13 GMT

HI All,

in Straight Table values are multiplying with 100 .i am not able to find out . client want out put as

1,2,3,4 but it showing 0.1,0.2,0.3,0.4 i tried in presentation tab i ts not working .i there any way to do this .i u Know plz tell me its aurgent

expression is

=(num(count({$<Date={"<=$(CNo)"}>}Date)/(Count({$<NAME1_LASTNAME,[ GROUP],Date>}TOTAL<Month,[ Year Name]>Date))))*100 &'%'

Re: Numerical Values in chart

PrashantSangle — Tue, 12 May 2015 09:48:29 GMT

Hi,

Just check in Property ->Number -> Show in % is tick or not.

Regards

Re: Numerical Values in chart

sunny_talwar — Tue, 12 May 2015 09:50:11 GMT

Try this and see if this gives an output you are expecting to see

=Num((Count({$<Date={"<=$(CNo)"}>}Date)/(Count({$<NAME1_LASTNAME,[ GROUP],Date>}TOTAL<Month,[ Year Name]>Date)))*100, '#,##0.0%')

Re: Numerical Values in chart

amit_saini — Tue, 12 May 2015 09:50:55 GMT

Hi,

Go to chart properties->Number->select your expression and decide the format.(Use as integer)

Thanks,

Re: Numerical Values in chart

Tue, 12 May 2015 10:23:36 GMT

thanks for all response.

i tried

=Num((Count({$<Date={"<=$(CNo)"}>}Date)/(Count({$<NAME1_LASTNAME,[ GROUP],Date>}TOTAL<Month,[ Year Name]>Date)))*100, '#,##0.0%')

=Go to chart properties->Number->select your expression and decide the format.(Use as integer)

but still not working

Re: Numerical Values in chart

avinashelite — Tue, 12 May 2015 10:28:02 GMT

can you please share your app

Re: Numerical Values in chart

Tue, 12 May 2015 10:32:45 GMT

is it should i cange total code for this ,and try another code then it work's plz tell

Re: Numerical Values in chart

PrashantSangle — Tue, 12 May 2015 10:33:56 GMT

In above formula either multiply by 100 or in Num format write %

Try

Num((Count({$<Date={"<=$(CNo)"}>}Date)/(Count({$<NAME1_LASTNAME,[ GROUP],Date>}TOTAL<Month,[ Year Name]>Date)))*100, '#,##0.0')

Num((Count({$<Date={"<=$(CNo)"}>}Date)/(Count({$<NAME1_LASTNAME,[ GROUP],Date>}TOTAL<Month,[ Year Name]>Date))), '#,##0.0%')

Regards

Re: Numerical Values in chart

sunny_talwar — Tue, 12 May 2015 10:35:08 GMT

As Avinashelite correctly pointed out, it would be easier if we see the application or a sample. Because without seeing it, we are all probably be guessing. Can you share a sample?

Best,

Sunny

Re: Numerical Values in chart

Tue, 12 May 2015 11:53:13 GMT

Changed The Total code still not working:

my Requirement is

document date | Reservation Date | diff Date( document-reservation date) | input box | output

2/1/2015 | 1/1/2015 | 1 | <=3 input box value/total Diff date*100

3/1/2015 | 1/1/2015 | 2 | 1+2+3=6 \ 6/11*100

5/1/2015 | 2/1/2015 | 3

10/1/2015 | 2/1/2015 | 5

11(total)

input box=value given by user <=3 1+2+3(6)

out put:6(input box)/total diff date*100

note;out put should be in integer

its aurgent plzz

Re: Numerical Values in chart

PrashantSangle — Tue, 12 May 2015 12:44:51 GMT

Hi,

Post your apps.

Regards,