topic Filter dimension in QlikView

Filter dimension

Fri, 07 Nov 2014 12:34:11 GMT

Hello, in cross table, I have 4 different dimensions and several expressions. One of these is calculating the amount of an order.

My boss is asking me to filter these orders with an input field. Therefore, I would like to add in the dimension a conditon (if, then...) so the dimension with the orders numbers can be filtered.

Let say for example that he wants to show only the orders with an amount higher than 1000€. In the input field, he wll wirte '1000' and the table will filter itself on that value.

Unfortunately, in a dimension, it'not possible to use an expression, so I'm not sure how to do this.

Thanks!

Re: Filter dimension

tresB — Fri, 07 Nov 2014 12:44:09 GMT

Fortunately there is 'Add Calculated Dimension ..': that could help you here(you can write an expression).

Re: Filter dimension

Fri, 07 Nov 2014 12:56:19 GMT

I'm already using these since I have other conditions. So to make it easier, I stored the expressions used in a variable and in that box, I wrote this:

$(tes01) >= AttvCAMin (which is the variable used in the input field. Unfortunately, it's not working.

Here is how the dimensions is:

=if(JD_NDEVIS_ATTENTE=(1) and date(JD_DATE_RAPPEL_MAX)<=Today(),

JD_NDEVIS & ' - ' & date(JD_DATE_RAPPEL_MAX))

this is working, but when I add '$(tes01) >= AttvCAMin' it's not working anymore 😕

Re: Filter dimension

tresB — Fri, 07 Nov 2014 13:01:33 GMT

Possibly the variable definition(with or without '=') or expansion could be the issue. Try to upload a your qvw sample that could be investigated.

Re: Re: Filter dimension

Fri, 07 Nov 2014 13:12:54 GMT

Here they are