Date Range

[ragsuha_9052]

Hi ,

Can any one suggest on how to get the column names date with month in Qlik Sense.

Please find the below snap for reference. I need sum of total cost with New supplier Group by .

Need a Total sum for  sum of Total cost Group by New Supplier, for ever 6th Jan - 5th Feb kind.

Thank You 

[ogster1974]

Looks like you need a custom master calendar for your dates.  Something like this.

If(Day(TempDate)>=6, '6th ' & MonthName(TempDate) & ' - 5th ' & MonthName(AddMonths(TempDate,1)),
If(Day(TempDate)<6, '6th ' & MonthName(AddMonths(TempDate,-1)) & ' - 5th ' & MonthName(TempDate))
) as CustomMonth

Will produce this 

Make it a dual to add sorting criteria.