Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ragsuha_9052
Contributor
Contributor

Date Range

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 .

ragsuha_9052_0-1674814380100.png

 

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

Thank You 🙂

Labels (1)
1 Reply
Vegar
MVP
MVP

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]