Create a column that is a percentage of subtotal

[qlikvi3465]

Hi!

I have the following data:

ID	Time
1	1
2	2
3	3
4	12
5	2
6	0

 etc.

I have represented in a graph the percentage of IDs that have the time 0, 1, 2, 3  and 12 (image 1).

I has used the next code:

=Num((Count(Time)*100/Count({T1}total Time))/100,'##,##%')

 

Now, I want to create a new column. This column is the percentage (with respect to the total) of the IDs whose time is < 3 (image 2).

I have tried with sum and aggr, count, etc, but I have not been successful.

Could you help me, please?

Thanks!

[uacg0009]

Hi,

It seems that you want to add a value in your dimension column,

so I think it's better to solve it in back-end, like you concatenate a part of data that the value of "time" column is time.

Aiolos Zhao

[qlikvi3465]

Hi Aiolos,

Thanks for you answer!

My problem is that the graph is linked to a List Box. The List Box contains the date when the measurement was made. Therefore, if I add the value in back-end, I won't filter the graph by date.

[uacg0009]

Hi,
Sorry, I don't understand your data model, I think it won't affect the list box even you add the value in the back-end.
If possible, could you please share a small sample to me, so I can try it?
Aiolos Zhao