Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jvankuilenburg
New Contributor

Group a distinct count

I am completely new to Qliksense, so please forgive me any stupid questions.

I have a large set of data (users and their usage of software packages). I have to analyse the usage of those software packages. I can make a pivot table like this:

UserAmount of packages
11
21

3

2
42
53
63

What I need however, is a table like this:

Amount of usersAmount of packages
21
22
23

How can I achive this?

3 Replies

Re: Group a distinct count

how did you get amount of packages???

is it existing field or are you using any expression for it?

Regards,

Regards,
Prashant Sangle
MVP
MVP

Re: Group a distinct count

May be use Amount of packages as dimension and Count(DISTINCT User) as expression?

Re: Group a distinct count

In Qliksense , you could simple drag and drop the charts you need , in your case

1.chose the pivot and

2.drag the necessary fields from the data set .

3.Pull the Users and Package to measure shelf you will get the option to chose out of sum() count() etc


  New to Qlik Sense Videos

Community Browser