topic Re: Clear object for Calendar in QlikView

Clear object for Calendar

himabinduch — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i have two calendar objects when i selected that rang it is working fine when i am trying clear all its not happening and i created a clear button for those object based on the variable but still it is not working could you please help on the same.

Thanks,

Hima.

Re: Clear object for Calendar

Anonymous — Thu, 09 Mar 2017 05:21:01 GMT

Hi Hima ,

If i understood properly you had 1. start date calendar object and 2. End Date Calendar object . what You want to clear now . Can you Please share Screen shot exactly what you want .

Re: Clear object for Calendar

nagarjuna_kotha — Thu, 09 Mar 2017 05:33:57 GMT

Hui,

Are you storing your selection in Variable and you want clear that variable value ,

if Yes,

Create on Text object and Goto to actions>>External>>Set Variable>>Give the Variavle Name>>Leave value with Empty

Or if you are not taking variable then you can use Clear fiels acton Type.

if you do not understand, please the sample app for the same.

-Nagarjun

Re: Clear object for Calendar

himabinduch — Thu, 09 Mar 2017 05:47:55 GMT

hi mahesh

i have create two variables assigned the same for the each calendar objects to get the range of the date when i am clicking clear all option my data is getting cleared except calendar objects please find the below.

Re: Clear object for Calendar

avinashelite — Thu, 09 Mar 2017 05:52:00 GMT

Clear button will not clear the Variable values . You need to create a button and add the action to set the calendar variable values according to your need ....this will cleat the calendar object too

Hope you got the answer

Re: Clear object for Calendar

ramasaisaksoft — Thu, 09 Mar 2017 06:10:53 GMT

Hi Bindu,

Calendar object with variables will show by default one value

(it is better to create like ,(it may be your variable date or else Today() ) so that while the page open trigger will show the this dates so user will also happy to see that date.

Document properties-->Triggers-->On Open(Document Event Triggers)-->Add-->Selection-->Clear All

if you feel your got solution for your issue,please close the thread by clicking "Correct Answer"

Re: Clear object for Calendar

himabinduch — Thu, 09 Mar 2017 06:20:42 GMT

Hi Avinash,

i created one button and added an action as external>>set variable>> variable name and value null

is anything else i have do from my end

Re: Clear object for Calendar

avinashelite — Thu, 09 Mar 2017 06:41:38 GMT

That should work , instead of setting the variable to null you could also get the to min and max of your date filed

Note: User show use the clear button created by you and when they use the default clear button by Qlik that does not clear the variable

Re: Clear object for Calendar

himabinduch — Thu, 09 Mar 2017 08:22:51 GMT

Hi Avinash,

i did the same but it is not working.

Re: Clear object for Calendar

avinashelite — Thu, 09 Mar 2017 10:09:29 GMT

share the sample app let me check

Re: Clear object for Calendar

nagarjuna_kotha — Thu, 09 Mar 2017 10:35:04 GMT

PFA...

Please check and confirm

Re: Clear object for Calendar

himabinduch — Thu, 09 Mar 2017 12:43:57 GMT

HI Nagarjuna,

the expectation has given by u is correct but while i am selecting date range it is not selecting the data in DATE field please check

Thanks,

hima

Re: Clear object for Calendar

himabinduch — Thu, 09 Mar 2017 13:02:09 GMT

Hi Rama,

it is not working i tried

Thanks,

Hima

Re: Clear object for Calendar

khalander — Thu, 09 Mar 2017 13:31:50 GMT

Hi Bindu,

PFA

Re: Clear object for Calendar

himabinduch — Fri, 10 Mar 2017 05:23:45 GMT

Re: Clear object for Calendar

himabinduch — Fri, 10 Mar 2017 05:25:17 GMT

Please find the sample data

Re: Clear object for Calendar

himabinduch — Fri, 10 Mar 2017 05:26:47 GMT

Hi Avinash,

please find the sample data.

Thanks,

Hima

Re: Clear object for Calendar

avinashelite — Fri, 10 Mar 2017 07:18:07 GMT

Since your have set the min() and Max() for the variable in the calendar it picking that in default ...try the action to set it for min and max you could see the difference ..

Re: Clear object for Calendar

nagarjuna_kotha — Fri, 10 Mar 2017 07:27:23 GMT

In the variable , it is storing values right,

So When you are using these varibale in your set analysis ,u need to set up with ur date fiels format,

I hope you got it .

-Nagarjun

Re: Clear object for Calendar

nagarjuna_kotha — Fri, 10 Mar 2017 07:35:27 GMT

PFA....