Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How do I calculate %

I have the following data

UserID       country            Region,        SerialNo    MonthYY

U1           USA,               Americas      C12            022011

U2           CANADA         Americas      C34             032011

U2           CANADA          Americas      C34             052011

U3           INDIA               Asia             C45             022011

U1           USA                 Americas     C12              032011

U4           UK                   Europe          C67             052011

U5           Italy                 Europe           C55             032011

U6           Singapore         Asia               C56             062011

I have created another barchart with Dimension: Region, Expression: Count (Distinct UserID)

This displays Number of Units in every Region as per below.

Region.JPG

Now I want to dispaly in %. i.e  %of Users in every region.  How do I enter expression?

Thanks

1 Solution

Accepted Solutions
Not applicable

Re: How do I calculate %

in the expressions tab, tick the "Relative" option.

I cant upload any images at the moment, so hope this helps

2 Replies
Not applicable

Re: How do I calculate %

in the expressions tab, tick the "Relative" option.

I cant upload any images at the moment, so hope this helps

Not applicable

How do I calculate %

Hi Andrew

Thanks. I tried as follows

Count (DISTINCT UserID)/ Count( TOTAL DISTINCT UserID)

your suggestion relative works. It is simple and easy.

Thanks for the quick help. Appreciate.