Discussion Board for collaboration related to Qlik Education.
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.
Go to Solution.
Check this topic:
use text object with following code may this helps you
=Count(if(Program = 'DETECT STOP',1)) &' / '& sum(If(Program <> 'DETECT STOP', PartsProduced))
13&318 is not the same as 13/318...
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.
script to generate test data
if(match(round(rand()*1),1),'DETECT STOP', '') as Program,
floor(rand()*10) as PartsProduced
2 overlapping textbox (layout --> layer), the text is
Breakdowns / Part produced
for the first one
=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)