How to calculate percentage when both measure are in the same field?

[Anonymous]

Dear Community,

I would like to know the correct formula, let's say:

Source	Type
Telephone	converted
Mobile	reserved
Telephone	others
Mobile	converted
Telephone	reserved

The outcome should be

Total count Source /Type(converted & reserved)

Thanks.

[qlikviewwizard]

Hi,

Can you show us your required output?

[qlikviewwizard]

Hi,

Check this. Is this required output?

Count:

LOAD * INLINE [

Source,Type

Telephone,converted

Mobile,reserved

Telephone,others

Mobile,converted

Telephone,reserved

];

[arvind1494]

Hi Ice,

First load your data

and use following expression in front end:

choose table

dimension = Source

Measure = count(total source)/count({<Type={'converted','reserved'}>}Type)