Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Specialist
Specialist

Hello!

Maybe this will be helpfull!

nilesh_gangurde
Partner
Partner

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