Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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.