Date Picker Not Working

[SoftUser]

Hi I m new to qliksense and i m using qliksense desktop version 13.9.1

My problem is that I have used a date picker for my worksheet and I used date field as my business date which I got from my QVD file. as suggest by some members I have used following variable in my data model section

SET BUSINESS_DATE = date([Calendar.Date],'DD/MM/YYYY');

But it did not work. I have select the respective range in date picker and it remains same. no result showing in my bar charts.

can some one help me regarding to this issue

[albertovarela]

I suggest you to add the BUSINESS_DATE  as a field 

e.g.

YourTableName:

LOAD 

        *, 

         date([Calendar.Date],'DD/MM/YYYY') as BUSINESS_DATE

FROM

        [YourQVD.qvd] (qvd)

;

[SoftUser]

Thank you for your response.

I have followed the same but I m getting an error. I have attached that

[albertovarela]

Instead of using [Calendar.Date] use the date field on your qvd

[SoftUser]

Thank you for your prompt response.

That also not gonna work. Is there any other configurations needs to done by the date picker calendar settings?

[SoftUser]

Once I pick a value from filter pane, date picker enables the sales dates of the exact brand. 

when I m going to get the sales sum for an exact date range all the dates are enabled but it's not showing the value. I can't understand what has happened to this. Please refer the screenshot

[albertovarela]

Can you post some sample data?

[SoftUser]

please find the sample data.

[albertovarela · Accepted solution]

Take a look at the attached qvf. All I changed was:

[SoftUser]

Thank you Alberto, Much Appreciated

Now its working 😃