Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sakshikaul
Creator II
Creator II

Declaring a variable using from and to variable in calender object

Hi,

I am suppose to migrate the qlikview application to qliksense app so for that I  want in my calendar object to declare 'FROM' and 'TO' variable. How to achieve the following ?

Following is the image showing the requirement in qlikview which I want to achieve in qliksense. How to achieve the same?

sakshikaul_0-1619406752232.png

 

/

8 Replies
MayilVahanan

HI @sakshikaul 

Try with Date picker, change the values based on ur requirement

MayilVahanan_0-1619407243141.png

 

MayilVahanan_1-1619407258092.png

 

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

Hi 

Do i need to take two date picker object ?

For "from" date  and "To" date separately?

sakshikaul_0-1619410695264.png

 

 

MayilVahanan

Hi @sakshikaul 

Yes, You can try as like Qlikview.

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

Hi,

Following steps i followed but not getting correct result 

1. click on variable. To edit variable

sakshikaul_0-1619419120481.png

 

2. Now I want to select a field ie invoice date and add min and max invoice date (see fig 2 ) just like its in qlikview (fig1) but I am not getting the date range( as in fig 3 qlikview).  Rather I am getting only single value  as shown in fig 4 .Please help 

Qlikview fig 1

sakshikaul_2-1619419294658.png

fig 2

sakshikaul_1-1619419166349.png

qlikview fig 3

sakshikaul_3-1619419434431.png

fig 4

sakshikaul_4-1619419518561.png

Please help...

 

MayilVahanan

Hi @sakshikaul 

Navigate calendar object doesn't satisfy ur requirement. 

You can try with some extension like below

https://developer.qlik.com/garden/56fe7589b96e94c440f1c94c

https://developer.qlik.com/garden/598c6b041cfdc8bde4c49def

 

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

Hi

Or,

MayilVahanan_0-1619424451908.png

Make the Calendar to Date Interval.

And assign MinDate and MaxDate in the variables (vFromDate & vToDate) like above

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

Hi ,

which object you have used to display min and max date variables?

MayilVahanan

KPI Object

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