Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
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]