Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm using a set analysis to sum the sales of a table like this:
It took me a while to find the problem, since it worked out last year. So I just realize when I finished that App it was from October on. And from October on, we have two digit Month i.e. 10-12
It works out without problem for my num(year(today())) part. But not for month:
So when I now just put the num(month(today())) in a KPI Window the number of today's month won't display as "01" but as "1".
So I guess for set analysis 01 is not the same as 1?
I hope someone knows a workaround to this.
Hi, are you sure, was single digit month cause of problem? It happened to me also. But first two days or considered as date, 3rd and forth day was not considered as date. When two files were merged like CSV and XLS. It was formed like that. Pl. Confirm that whether single date not shown from single digit date.
thank you for your tip. It indeed was "one" of the problems. I really needed to make 01=1 work first, to filter the right sales data. But there was really also another mistake that I had to figured out.