how connect my calendar to mat charts and tables

[nazaninslp]

Dears

I have DIME_DATE table in Sql

I have crated calendar with started and end date that gets from user.

I want to to connect this inputs to my charts and table

and when user enter the start and end date , it should be changed and extract report.

would you please help.

I have attached my Qlikview file.

[kaushiknsolanki · Accepted solution]

Hi,

Add below link in your expression's Set analysis.

DATE_KEY = {">=$(=Date(vstartdate))<=$(=Date(venddate))"}

For example.

sum({<Area_Category-={"Test","Free ShortCode","Xtratime","ACS","Cloud"},DATE_KEY = {">=$(=Date(vstartdate))<=$(=Date(venddate))"}>}REVENUE)

Regards,

Kaushik Solanki

[nazaninslp]

Dear Kaushik
Thank youuuuuuuu
it is working fine, but when I press Clear Button , it doesn't apply to whole my sheet, and stay in date selection mode.
how can I fix it.

[kaushiknsolanki]

Can you share screenshot of that to understand it in detail.

Also if possible create a new post, because the topic of this post is different.

After creating post do tag me, or mail me the URL of that post.

Regards,

Kaushik Solanki

[nazaninslp]

Dear Kaushik
I've created new post
please help me
post detail:
How to Clear Date Values in Calendar Object and show the default value of started_date,End_date