Dissociate one dimension from Another - Qlik Community

enricocamerin · ‎2018-10-02

Hello I have 2 time dimensions.

I need to dissociate the 2 dimensions.

month_dim1,

month_dim2

So if I apply a filter on the first dimension I don't want the second dimension to respond to the particular value in the filter

In the set analysis we can do this in a measure expression

count ({< month_dim1= >} distinct RESOURCE_ID)

in this case the count remain the same when a a filter is applied on the first time dimension

but I haven't found a way to do the same for dimension

I tried with a calculate dimension but it doen't work.

if the filter is applyed on month_dim2 the month_dim1 respond to the filter as well

minstring is just a function to let me use set analysis it can be every function

month_dim1 = aggr ( MinString ( {< month_dim1= >} month_dim1)

thanks

Enrico

vitaliichupryna · ‎2018-10-02

Hi,

You can use alternate states

enricocamerin · ‎2018-10-02

Thanks for reply, but we are using qliksense and we are not allowed to use extension.

vitaliichupryna · ‎2018-10-02

In this case for example you can create data island with necessary data