Date Range

ragsuha_9052 — Fri, 27 Jan 2023 10:15:31 GMT

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 🙂

Re: Date Range

Vegar — Sun, 29 Jan 2023 09:25:30 GMT

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]