topic Re: Ordering of Filter values gets disturbed when using expression in Filter in QlikView

Ordering of Filter values gets disturbed when using expression in Filter

Wed, 02 Jul 2014 07:48:55 GMT

Hi Experts,

We have been facing an issue while applying filters.

We have 2 filters say Filter A and Filter B, we are using an expression to populate values in Filter B. Filter A fetches values from dimension directly.

Now when we choose some value from Filter A, the corresponding value in Filter B doesn't comes up on top of filter, which should be the normal functionality.

Instead if we use the Dimension in the Filter B , then it pushes the value of the corresponding filter B value on top.

Screenshots have been attached for your reference of filter A, filter B with expression and filter B with dimension only.

Please suggest how we can push the values for filter B up using expressions!!!

P.S.: For Filter B, Hide excluded option has been checked so other values are not shown.

Thanks in advance.

Shitiz

Re: Ordering of Filter values gets disturbed when using expression in Filter

hic — Wed, 02 Jul 2014 07:57:41 GMT

This should work automatically if you have set the sort option "Sort by State" to Ascending or Auto Ascending.

HIC

Re: Ordering of Filter values gets disturbed when using expression in Filter

Wed, 02 Jul 2014 09:02:46 GMT

Hi HIC,

This is option is already been checked on the Filter, still its not working.

I have changes it to Ascending also, but no change .

Regards,

Shitiz