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

[Anonymous]

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.

[sunny_talwar]

May be this

Dimension

organization_name

Expression

Count(DISTINCT project_name)

[VishalWaghole]

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

[Clever_Anjos]

Add as dimensions

• monthstart(project_create_date)
• organization_name

As measure : count(distinct project_name)