topic Re: Dissociate one dimension from Another in App Development

Dissociate one dimension from Another

enricocamerin — Tue, 02 Oct 2018 07:03:31 GMT

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 — Tue, 02 Oct 2018 07:07:51 GMT

Hi,

You can use alternate states

enricocamerin — Tue, 02 Oct 2018 07:19:17 GMT

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

vitaliichupryna — Tue, 02 Oct 2018 07:20:40 GMT

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