Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
karunaramteke
Contributor III
Contributor III

How to implement calendar objects

Hi all,

 

I have a date column (Complete.postingDate) 

I want to implement calendar object in it min and max Date.

I have tried using variable and gave min and max range ., however that is not reflecting my chart object.

 

Please help.

Please find attached reference qvw sheet3.

Thanks in advance.

 

 

6 Replies
edwin
Master II
Master II

@karunaramteke  - there is no attached QVW.  can you pls re attach?

karunaramteke
Contributor III
Contributor III
Author

 
karunaramteke
Contributor III
Contributor III
Author

Can anybody please help me to get calendar  object.

edwin
Master II
Master II

is your problem min and maximum showing number?  in the top 2 objects?

date is a dual type (meaning it has text (this is the format you see like MM/DD/YYYY).  min function returns a number so just use the date function

date(min(dateField))

karunaramteke
Contributor III
Contributor III
Author

No it turns into number . I tried it.

In one calendar obj I want to select date

 eg: 01-10-2020 and in other calendar obj I want to select 31-10-2020.

 

MayilVahanan

Hi @karunaramteke 

For your case, you need to use trigger .  PFA

Actually, am not sure why you are using table box instead of straight table.

Alternate, If you are using the straight table, you can use set analysis instead of trigger.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.