Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I chart the following Data with the following needs

Hi Have approx. 45000 user data. When I group them 10% based on the REWARDS , All Data are one sided.

COUNT(USER_ID)

Picture1.png

SUM(REWARDS)

Picture2.png

To simulate, I have created a Dummy Data.

I want to group the Users into 10% in one group. The challenge is to select 10% users based on the Field(REWARDS) I have highlighted the User group in different colour in excel file for easy understanding. How do I group users based on colour I  marked?

Thank you

2 Replies
Not applicable
Author

Hi,

I believe the way you do it, it would use the rule that you used to color in the file when importing data.

Rebeca

Not applicable
Author

manually I can highlight and select. i.e I Sorted the REWARDS, then I took user count/10. Then I took firs 10% of users and highlight in one color and next 10% in another color ..so on.

I made an attempt (Refer to Variables.PNG) in previous thread.

I do not know how to select and map users in group of 10% but based on the REWARDS. Hope some qlikview experts around here can help..