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: 
himanshi
Contributor III
Contributor III

creating a date field

hi community,

i have a table in which i have year and month field and a quantity field now i need to display quantity for all dates of a month.

how to do that i don't have a day numbers.

in the below attachment file i need to display the same sales plan for each date of a month instead of 1 only.

Regards

4 Replies
dinuwanbr
Creator III
Creator III

Hi,

That means u need to load all the dates and where there is no sale then it as zero. Am I correct?

Better if u can upload a sample.

BR,

Dinu1

himanshi
Contributor III
Contributor III
Author

Hi Tharindu Ranathunge,

thanks for reply‌. yes you are correct somewhere their is data for month only. and its done  i have used this expression-

=sum({<[Common Day Number] =>}total<[Common Fiscal Month Name],[Common Year Display]>CommonQty)

Regards,

Himanshi

t_chetirbok
Creator III
Creator III

Hello!

Maybe this will be helpfull!

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi,

In Datamodel Link your plans on the Monthname Field. Dont Link the plans on the Date Field. Currently you are linking on the basis of Date, change it to Monthname.

This will automatically Show plans for each day of the month.

Regards,

Nilesh