topic creating a date field in QlikView

creating a date field

himanshi — Fri, 20 Nov 2020 18:02:30 GMT

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

Re: creating a date field

dinuwanbr — Mon, 18 Jan 2016 08:50:28 GMT

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

Re: creating a date field

himanshi — Mon, 18 Jan 2016 09:00:36 GMT

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

Re: creating a date field

t_chetirbok — Mon, 18 Jan 2016 09:06:25 GMT

Hello!

Maybe this will be helpfull!

Re: creating a date field

nilesh_gangurde — Mon, 18 Jan 2016 09:08:31 GMT

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