Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I would like to create a chart and only show the first day of each month as a dimension.
For this I used the following formula:
date(monthstart(ypA_FO_OP.Date))
The KPI is:
Sum([ypA_FO_OP.OpenValue])
Unfortunately, Qlik adds up the total days in each month.
If I don't use "Sum", only 01.07.2022 appears and this is not complete either.
Can you help me please?
Hello,
I am not 100% sure that I understood the combination of KPI and "show the first day of each month", because KPI will display only one value. Are you looking to summarize all the values for the first day of each month?
In any case, if you are looking for a way to implement an visualization by showing only the first day of each month as dimension you can use the dimension expression: =If(Date=MonthStart(Date), Date, Null())
For example, here is the Straight table with all the values:
And here is the Straight table where dimension is using the expression above:
Another example is the bar chart with all the values:
And here is the Bar chart where dimension is using the expression above:
As you can see it only shows the first day of each month.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
Hello,
I am not 100% sure that I understood the combination of KPI and "show the first day of each month", because KPI will display only one value. Are you looking to summarize all the values for the first day of each month?
In any case, if you are looking for a way to implement an visualization by showing only the first day of each month as dimension you can use the dimension expression: =If(Date=MonthStart(Date), Date, Null())
For example, here is the Straight table with all the values:
And here is the Straight table where dimension is using the expression above:
Another example is the bar chart with all the values:
And here is the Bar chart where dimension is using the expression above:
As you can see it only shows the first day of each month.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
Thank you very much for your detailed answer. It works! 😀
how to use this as measure please.