Discussion board where members can get started with Qlik Sense.
Can someone tell me how to do a bar chart like below. I cant get it right.
Do you have a calendar? If yes, put your yearmonth as dimension, if not put Monthname([Created date])) as Dimension.
Create two expressions, one for the created date and another one with Decision
The created one should be Count(DISTINCT [Created date])
The decision date one should be similar.
Thanks, but it doesn't present the right data. Please see below. One pic with Distinct Count and the other with only Count.
The third pic shows the real data.
I am thinking the problem is the dimension? It should be a neutral date/calendar? That's not connected to Createddate or decisiondate?
Hi! I would suggest that you get your database in different shape so you can use month as dimension:
Then in the bar chart use:
let's try using the below script:
[created date] as CalendarDate
from your_table where len(trim([created date])) > 0;
[decision date] as CalendarDate
from your_table where len(trim([decision date])) > 0;
finally in your bar chart you can use MonthName(CalendarDate) as dimension.
I get an error,
i think you should replace "your_table" with your real table name.
and i guess you have to replace "from" with "Resident" if you already loaded it.
Embarrassing, of course. I will check it out when I can give it my full attention. I will get back to you.
Can you share de qvf with this data?