topic Re: Dt in QlikView

Dt

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: Dt

vinieme12 — Thu, 06 Apr 2017 05:21:28 GMT

You need a master calendar to fill the dates

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

Re: Dt

smilingjohn — Thu, 06 Apr 2017 05:55:42 GMT

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 ......

Re: Dt

Anil_Babu_Samineni — Thu, 06 Apr 2017 06:02:51 GMT

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

Re: Dt

smilingjohn — Thu, 06 Apr 2017 06:16:27 GMT

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 .

Re: Dt

Anil_Babu_Samineni — Thu, 06 Apr 2017 06:48:16 GMT

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

Re: Dt

smilingjohn — Thu, 06 Apr 2017 09:03:10 GMT

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)) ?

Re: Dt

Anil_Babu_Samineni — Thu, 06 Apr 2017 09:18:12 GMT

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

Re: Dt

Anil_Babu_Samineni — Thu, 06 Apr 2017 09:28:08 GMT

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

Selection

No Selection