Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
himanshi
New 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
Highlighted
dinuwanbr
Contributor III

Re: creating a date field

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

Highlighted
himanshi
New Contributor III

Re: creating a date field

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

Highlighted
t_chetirbok
Valued Contributor

Re: creating a date field

Hello!

Maybe this will be helpfull!

Highlighted
Partner
Partner

Re: creating a date field

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