topic Re: Class & Age Function in QlikView

Class & Age Function

wonkymeister — Wed, 23 Apr 2014 10:21:39 GMT

Morning all!

i use the Class and Age functions to create age bands in a table for employee date of births i.e.

=Class(Age('$(vMyDate)',date_of_birth),5,'Age Band' ) -- where vMyDate is a variable storing todays date

Now this displays perfectly as you'd imagine, as a list of staff by age bands. The problem that i have is that when an age band is selected and therefore the results restricted you cant deselect it to go back to the full list.

i guess this is because the user isn't actually selecting an age band, but what is essentially a function.

does anyone know of any workarounds to make it de-selectable?

thanks in advance

Re: Class & Age Function

tresB — Wed, 23 Apr 2014 10:25:15 GMT

Could you post your sample qvw that demonstrates the issue?

Re: Class & Age Function

wonkymeister — Wed, 23 Apr 2014 10:33:00 GMT

complete list:

then select a band:

the user is now unable to deselect the band and go back to the full list.

Re: Class & Age Function

MK_QSL — Wed, 23 Apr 2014 10:35:49 GMT

Have you tried to create a button with action clear all ?

Re: Class & Age Function

wonkymeister — Wed, 23 Apr 2014 10:38:17 GMT

thanks, but i dont want to clear all, i just want to de-select the selected band.

Re: Class & Age Function

MK_QSL — Wed, 23 Apr 2014 10:40:24 GMT

What happens when you again click on the same age band?

Re: Class & Age Function

wonkymeister — Wed, 23 Apr 2014 10:43:04 GMT

nothing. the field turns green on click, but doesn't deselect.

its displayed as in current selections (PA0002_Gbdata is the date of birth field):

Re: Class & Age Function

MK_QSL — Wed, 23 Apr 2014 10:45:36 GMT

It's difficult to answer now...

can you please upload your sample apps with reduced or dummy data?

Re: Class & Age Function

jonathandienst — Wed, 23 Apr 2014 11:08:59 GMT

As you have seen, selecting a row is effectively selecting a range of date_of_birth fields. You could create a button with the action of clearing the selections in the date_of_birth field. You could even give this button (or text box) the little eraser icon and position it on the caption over the current eraser icon. Make sure that the button/text box is on a higher layer than the table.

HTH

Jonathan

Re: Class & Age Function

wonkymeister — Wed, 23 Apr 2014 11:12:53 GMT

I had a feeling it was a non-starter Jonathan.

Thanks all for the replies and help.

Re: Class & Age Function

MK_QSL — Wed, 23 Apr 2014 11:19:56 GMT

Check enclosed file...

Re: Class & Age Function

lukaspuschner — Wed, 23 Apr 2014 11:27:40 GMT

if you only want to deselect the selected band, may this will help you...

Re: Class & Age Function

wonkymeister — Wed, 23 Apr 2014 11:34:56 GMT

Thanks Manish, interesting to see a different approach.

It still wont deselect though. QV just thinks its selecting a group of DOB's

Thanks again Manish

Re: Class & Age Function

wonkymeister — Wed, 23 Apr 2014 11:35:34 GMT

thanks Lukas

Re: Class & Age Function

MK_QSL — Wed, 23 Apr 2014 11:47:03 GMT

You mean to say when you select Say ... 10 <= Age Band < 15, you can't deselect it...

If I wrote above is true, there should be some bugs in your QlikView Version, as I am able to deselect it...

let me know...

Re: Class & Age Function

wonkymeister — Wed, 23 Apr 2014 11:59:07 GMT

Manish,

i think it may have something to do with the data model that i'm working with. I dont quite understand to be honest.

its quite confusing! all other tables /charts select/deselect as normal. its just the tables that use calculated dimensions that are proving to be problematic!