Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

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

Dear Community,

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

SourceType
Telephoneconverted
Mobilereserved
Telephoneothers
Mobileconverted
Telephonereserved

The outcome should be

Total count Source /Type(converted & reserved)

Thanks.

3 Replies
Master II
Master II

Hi,

Can you show us your required output?

Master II
Master II

Hi,

Check this. Is this required output?

Count:

LOAD * INLINE [

Source,Type

Telephone,converted

Mobile,reserved

Telephone,others

Mobile,converted

Telephone,reserved

];

Capture.JPG

Specialist
Specialist

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)