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 🙂

[Vegar]

you can solve this in the script by creating a new custom month field.

This is one way that might achieve what you're trying to do.

if (Day([Date])<6, 

dual('6th ' & date(monthstart([Date],-1),'MMM') & ' - 5th ' & date(monthstart([Date]),'MMM'), monthstart([Date],-1)),

dual('6th ' & date(monthstart([Date]),'MMM') & ' - 5th ' & date(monthstart([Date],1),'MMM'), monthstart([Date]))

) as [Custom Month]