topic Displaying a number as a proportion please help. in Qlik Learning Discussions

Displaying a number as a proportion please help.

Sun, 25 Jan 2015 17:20:06 GMT

Hello. I am new to QlikView and I am trying to reproduce a box like the one shown in the picture attached.

First I am not even sure what object I should Use. I have been using text objects and for this one I have a formula as follows.

=Count(if(Program = 'DETECT STOP',1)) / sum(If(Program <> 'DETECT STOP', PartsProduced))

But I get a decimal representation and I want a fraction.

Any help on the object and setting I need to choose or even add/change code would be appreciated.

Sun, 25 Jan 2015 17:31:05 GMT

use text object with following code may this helps you

=Count(if(Program = 'DETECT STOP',1)) &' / '& sum(If(Program <> 'DETECT STOP', PartsProduced))

robert_mika — Sun, 25 Jan 2015 18:50:57 GMT

13&318 is not the same as 13/318...

robert_mika — Sun, 25 Jan 2015 18:51:14 GMT

Check this topic:

maxgro — Sun, 25 Jan 2015 19:06:33 GMT

see attachement

Sun, 25 Jan 2015 23:20:33 GMT

Do you mind pasting the code since I am only using the personal version of Qlikview which does not allow for the opening of other peoples .qvw files.

maxgro — Mon, 26 Jan 2015 08:33:00 GMT

script to generate test data

load

if(match(round(rand()*1),1),'DETECT STOP', '') as Program,

floor(rand()*10) as PartsProduced

AutoGenerate

1000;

2 overlapping textbox (layout --> layer), the text is

Breakdowns / Part produced

for the first one

and

=num(Count(if(Program = 'DETECT STOP',1)),'#.##0') &' / '& num(sum(If(Program <> 'DETECT STOP', PartsProduced)),'#.##0')

for the second

I use 2 textbox (top in image); another option could be, with one textbox, to put Breakdown....... in the caption (bottom in image)