Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a file containing, among other things, a date field (2017-06-14) and another field containing sales number.
I would like to summarize sales per month as in the example below, summing May and June separately.
I have tried to create dimensions with wildmatch but I can not use that dimension as a field.
Do you have any suggestions?
This is true of Qlik sense desktop
I´m not sure i understand what you mean, kinda new to Qlik.
If I want to use it as an expression to show number in a meter, lets say I want to sum alla sales for 2017-05.
Even when I try to sum a specifik date i get Zero i result:
I have created a dimension called Month like this, if(wildmatch(Date,'2017-05*'),'Maj17','Other')
This works fine but can i use the dimension in a if statement like sum(if(Month='Maj17',Sales))
Befor the last uppdate this worked fine but no i get wrong fieldname in Month.
I will try put it like this.
All I want to do is so sum the sales for a month based on the dates.
How can I sum sales for May based on this information?