Discussion board where members can get started with Qlik Sense.
First of all, I'm not fluent in english, sorry for that.
Sencond, thanks in advance for any kind of help you can provide me.
Here is the situation.
I'm exploring some solutions to explote de data in a datamart and I have a problem with a metric.
I'm trying to create a single metric to measure the quantity of clients.
The behaviour of the metric should be the next:
When the level of analysis is "month" the metric should show the number of clients in that mont ( SUM(CLIENT_QUANTITY) )
But, when the level of analysis is "year" the metric show show the number of clients in the
last month's year that have data.
The (partial) structure of the data mart is the next:
DATE_STR (the representation of the date in dd/MM/yyyy format)
MONTH_NUMBER (with values from 1 to 12)
MONT_YEAR (an integer value compossed by YEAR*100 + MONTH_NUMBER)
The fact table:
is a factless fact, and its granularity is one record per client at the first day of the mont
CLIENT_QUANTITY (always 1)
I look forward for your reply.
you can try to sum the quantity of the max month with quantity, something like
You can aggregate the metric
Or Use Drill Down Qilsense
Drill Down Dimensions in Qlik Sense
Thanks maxgro for your answer.
The metric worked ok, but it only shows the value for the last month in the last year.
I need the same value but for every last month (with data) in every year. Is there a way to achive this?