topic Always one selected value in QlikView

Always one selected value

sibin_jacob — Thu, 10 Jan 2013 13:48:30 GMT

Hi,

I need to set always one selection for Team. I used one listbox for Team with always one selected option.

But at that time I am not able to change the District selection,

Is there any way to set default selection for Team ?

I need every time one Team get selected.Here I am attaching my application.

Thanks,

Sibin Jacob.C

Re: Always one selected value

Thu, 10 Jan 2013 15:29:04 GMT

Hi Sibin,

I attached a solution

Hope this helps

Regards!

Re: Always one selected value

Vegar — Thu, 10 Jan 2013 15:53:15 GMT

A solution to your problem is to use a trigger on the Team field using a concat-funtion. See picture and attached file.

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se

Re: Always one selected value

sibin_jacob — Thu, 10 Jan 2013 17:55:00 GMT

Thanks for your Reply, But in this attached file I am not able to select District2.

I need always one team selected based on district selection.

Regards,

Sibin Jacob.C

Re: Always one selected value

sibin_jacob — Thu, 10 Jan 2013 17:58:21 GMT

Hi Gabriela Morales thanks for your replay, But in this attached file I am not able to select District2.

Regards,

Sibin Jacob.C

Re: Always one selected value

Thu, 10 Jan 2013 18:00:40 GMT

hum...thats weird, I am able to select it

Re: Always one selected value

Vegar — Fri, 11 Jan 2013 07:15:04 GMT

The reason you're not able to select District2 is because you have turned on the limitation "Always one selected value". By choosing District2 you also try to cancel the current Team selection hence you only got one district per team. I've provided a sample where I added a single row on team3 to show what I'm trying to explain.

LOAD * inline [
Nation, District, Team, Vol
Nation, District2, Team3, 1
];

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se