topic Re: Forced selection of associated data in QlikView

Forced selection of associated data

YoussefBelloum — Wed, 04 Oct 2017 09:09:29 GMT

Hi Guys,

The app is attached below,

On a table i have a dimension and a cyclic group, the dimension change depending on the cyclic group change (with Getcurrentfield(cyclic_group) associated with a variable).

The problem is when I choose a dimension, all the associated data is selected, not just filtered..

Thank you

Re: Forced selection of associated data

jelle_vervloess1 — Wed, 04 Oct 2017 11:07:42 GMT

Hi youseff

i dont know why he selects the hic3 this should not happen as far as i know but you can force your measure to ignore the hic3 field by setting it to nothing in your set expression like so:

{<hic3=>}

i tried loading your qvw file but it didn't work

Re: Forced selection of associated data

YoussefBelloum — Wed, 04 Oct 2017 11:53:34 GMT

Hi,

I can't do that, because i need to use it when the cyclic group = Sous Groupement, which is HIC3..

Thanks anyway

Re: Forced selection of associated data

Kushal_Chawda — Wed, 04 Oct 2017 12:54:41 GMT

create variable vGroup and write below expression

=if(v_Group_lib='Groupement','HIC2',

if(v_Group_lib='Sous groupement', 'HIC3'

)

Now use vGroup variable as dimension in chart

see the attached

Re: Forced selection of associated data

YoussefBelloum — Wed, 04 Oct 2017 13:04:50 GMT

Hi Kushal,

it works on the first selection, but when i use the cyclic group to show the second dimension, the table is empty...

Something is missing i think

Thanks

Re: Forced selection of associated data

Kushal_Chawda — Wed, 04 Oct 2017 13:09:15 GMT

sorry expression was wrong,.. use your original expression

Re: Forced selection of associated data

YoussefBelloum — Wed, 04 Oct 2017 13:13:46 GMT

Thanks, it works !

Can you tell me why with an IF it doesn't work ??

It looks like a Bug or something, can you confirm ??

Re: Forced selection of associated data

Kushal_Chawda — Wed, 04 Oct 2017 13:30:27 GMT

yes. seems to be a bug only.

or functionality wise if you select the particular value from one dimension it aggregates the other dimension value included in if statement. This is similar to below expression

aggr(if(v_Group_lib='Groupement',HIC2,

if(v_Group_lib='Sous groupement', HIC3

)

),HIC2,HIC3)

To avoid other dimension value to be selected, you can use below expression, but this work only for current cyclic group dimension if you change the cyclic group dimension, it will not work

aggr(if(v_Group_lib='Groupement',HIC2,

if(v_Group_lib='Sous groupement', HIC3

)

),HIC2)

Re: Forced selection of associated data

YoussefBelloum — Wed, 04 Oct 2017 13:52:01 GMT

I see..

Thanks a lot !