topic Re: Always one selected value in Calendar Object in QlikView

Always one selected value in Calendar Object

Anonymous — Tue, 01 Sep 2015 07:29:55 GMT

Hi All,

Is it possible to set always one selected value in calendar object like in list box .

Any Ideas

Re: Always one selected value in Calendar Object

sunny_talwar — Tue, 01 Sep 2015 07:38:03 GMT

I think it should be possible if you are using a field (and not a variable). Create a list box object for the field you are using in the calendar object and select Always one Selected option. Delete the list box and it might work for the calendar object.

NOTE: I have never done this before, but this technique works for Multi Box object.

HTH

Best,

Sunny

Re: Always one selected value in Calendar Object

sunny_talwar — Tue, 01 Sep 2015 07:41:09 GMT

Seems to work. Please find attached.

Best,

Sunny

Re: Always one selected value in Calendar Object

parthakk — Tue, 01 Sep 2015 07:45:57 GMT

Hi Sunny,

I tried your method and it works..

Re: Always one selected value in Calendar Object

gautik92 — Tue, 01 Sep 2015 07:53:37 GMT

is it possible if we use variables

Re: Always one selected value in Calendar Object

sunny_talwar — Tue, 01 Sep 2015 07:58:25 GMT

It seems that variable already allow for only one selection only. See the attached:

Re: Always one selected value in Calendar Object

Anonymous — Tue, 01 Sep 2015 10:01:50 GMT

Hi Sunny

Thanks your technique is working .

But whenever i make clear selections clear action is not getting applied on remaining objects .

Thanks

Re: Always one selected value in Calendar Object

sunny_talwar — Tue, 01 Sep 2015 10:07:28 GMT

Yes once 'Always One Selected' option is selected, you won't be able to clear the field. You might want to consider an alternative in that case. What exactly are you trying to do?

Re: Always one selected value in Calendar Object

Anonymous — Tue, 01 Sep 2015 10:14:23 GMT

Yes , i tried with alternate states ,but it didn't solve my purpose.

My requirement is I need to clear the selections on all objects .But my calendar object shouldn't get cleared.

I tried altrnate states.

Note :In my application all selections are based on calendar object only.so i can't use alternate states.

Thanks

Re: Always one selected value in Calendar Object

sunny_talwar — Tue, 01 Sep 2015 10:17:42 GMT

When you say clear, you mean that even if a field is filtered by the date selection, it should be cleared? That to me doesn't seem to be possible, because as soon as you will make a selection, fields which are out of scope will turn grey in the other field's list boxes. May be use a variable instead of date field?

Re: Always one selected value in Calendar Object

Anonymous — Tue, 01 Sep 2015 10:34:40 GMT

Below screen shot , i have selected date ,and three list boxes.

In the above screen shot i made clear selections ,then two list boxes got cleared.But calendar object doesn't get cleared.

That is the functionality i am looking for.

Thanks

Re: Always one selected value in Calendar Object

sunny_talwar — Tue, 01 Sep 2015 10:41:41 GMT

Isn't this the way the it is already working?? I would think it is. What is it doing right now???

Re: Always one selected value in Calendar Object

Anonymous — Tue, 01 Sep 2015 11:11:45 GMT

The functionality is already in one of the dashboard.

Now i need to implement the same functionality

Re: Always one selected value in Calendar Object

sunny_talwar — Tue, 01 Sep 2015 11:14:20 GMT

I meant what I proposed in the solution I gave you earlier where you can select only one date from the calendar doing this. When you clear everything else should clear except the calendar linked field?

Re: Always one selected value in Calendar Object

avinashelite — Tue, 01 Sep 2015 11:50:11 GMT

As sunindia‌ said the implementation with the variable will serve your requirement . If you use a field with Always single select check , we don't have option ti clear and its against the logic of Always single select check.

Try with variable, if you want to go only with field than you can try like disable the calendar i.e by hiding the calendar with a msg ...

Re: Always one selected value in Calendar Object

Tue, 01 Sep 2015 11:57:22 GMT

Another option if you do not use a field is to create a button and define the actions as to which fields you want to clear

Re: Always one selected value in Calendar Object

qlikviewwizard — Wed, 02 Sep 2015 02:02:09 GMT

Hi RGV,

P.S: When we slect 'Always one selected Value', it won't be cleared when we use Clear ALL

Can you please attach the sample file with the data to demonstrate your issue.

Re: Always one selected value in Calendar Object

Anonymous — Wed, 02 Sep 2015 05:22:43 GMT

Hi qlikviewwizard

Thanks for your reply !!

I am aware of what you mean to say ,but i want to clear rest of all the selections in dashboard in which 'Always one selected is not applied .

Test:

LOAD * INLINE [

Product, Price

Car, 100

Bike, 50

Cycle, 30

];

calendar:

LOAD * INLINE [

Date, Value

1/1/2013, 100

2/1/2011, 200

3/2/2014, 300

4/5/2014, 500

];

calendarobject using date field in Calendar table .

Re: Always one selected value in Calendar Object

qlikviewwizard — Wed, 02 Sep 2015 05:31:22 GMT

Hi RGV,

What is link betwen Calendar and Test?

Value=Price?

Re: Always one selected value in Calendar Object

Anonymous — Wed, 02 Sep 2015 05:48:20 GMT

There is no link between them .

for understanding the scenario i hav e posted the example.

My reqirement is to clear all the objects except the date in the calendar object.

Thanks