Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

winnie_chan
New Contributor II

How to count the number of project created by organization per month?

Hi,

I'm new for Qlik, and struggling how to create a chart to show the number of project created by each organization per month.

In my data, there are the following field:

  • organization_name
  • project_name
  • project_create_date

Thanks in advance.

3 Replies

Re: How to count the number of project created by organization per month?

May be this

Dimension

organization_name

Expression

Count(DISTINCT project_name)

vishalwaghole
Valued Contributor II

Re: How to count the number of project created by organization per month?

Once you load data into qlik sense then go to edit sheet option.

Under sheet you will get chart menu from left panel. Drag bar chart from chart panel, and add dimension as organization_name and expression as count(distinct project_name)

Thanks,

Vishal

Employee
Employee

Re: How to count the number of project created by organization per month?

Add as dimensions

  • monthstart(project_create_date)
  • organization_name

As measure : count(distinct project_name)

Community Browser