Dt

[smilingjohn]

HI ALl ,

I have attached the QVW ,, and if you look into the table of date , you will see that there is no date for 2016-08-02 and 03 .( 2nd and 3rd of August)

I want to use some date fucntionality in the script which has to generate the missing date .....

Is it possible ?

[vinieme12]

You need a master calendar to fill the dates

https://qlikviewcookbook.com/2015/05/better-calendar-scripts/

[smilingjohn]

I already do have master calendar ..

Actaully i have a count of id's   and when  select the date from master calendar 2nd of feb , the count of id's should show 0 .

this is what i want ......

[Anil_Babu_Samineni]

In your data where does Id's are? I am not seeing Id's over there

[smilingjohn]

Hi Anil,

please find my attachment ...

Actaully this is just a dummy data for example , in my real time application i have  everything master calendar and all , from the data base iam getting the date field which has no data for certain dates, and when user click on the date  says 2feb on the mastercalendar which is placed the count of data shows overall , now i want to use some expression or something like that where when the date is selcted which is not present in the db , the count of leads should show 0 value .

[Anil_Babu_Samineni]

You may forget the benefits of Master Calendar. Here, Master calendar consists only generate the dates and missing values. Here, you are loading from Tabular source. Here, What was the issue is you already have the date in excel with one value

In fact, If you generate only missing dates or values it will work as you expected. But, Master calendar creates and associate with existing date field. So, Have a look here

Discussion already done and thread owner is stalwar1‌

Use of Master Calendar

[smilingjohn]

Hi Anil

please look for 2nd of AUGUST ....... there is no date available.

can i use any expression like this if(Date='',0,count(ID)) ?

[Anil_Babu_Samineni]

You can use that in real data

Even you can try like below -- If(IsNull(Date), 0, Count(ID))

And you've mentioned you used Master Calendar. But, Why August 2016 Data is not filling. It should fill while you created Master Calendar. And, It work as you expected. Would you share excel file also. And can you let me know which case and where you get this data coming from

[Anil_Babu_Samineni]

FYI, Attached sample. I used this for text box =Count({<ID -= {''}>}ID)

Selection                                                                     

No Selection