Discussion board where members can get started with QlikView.
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.
Now I want to dispaly in %. i.e %of Users in every region. How do I enter expression?
Go to Solution.
in the expressions tab, tick the "Relative" option.
I cant upload any images at the moment, so hope this helps
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.