topic Re: Limit shown dimension values in QlikView

Limit shown dimension values

curiousfellow — Thu, 17 Sep 2015 12:01:44 GMT

I have a listbox in which I select a period.

In a pivot table all periods less than or equal than the selected period are presented as a dimension.

When I use the next formula as a calculated dimension I don't get what i want :

if(period < $(chosen_period),period)

Is it possible to limit the dimensions with a formula ?

marcus_sommer — Thu, 17 Sep 2015 12:08:10 GMT

This approach is possible - I think in your case is either the field or the variable or both not numeric and then an operator like <>= will fail.

- Marcus

curiousfellow — Thu, 17 Sep 2015 12:49:02 GMT

Both are numeric, so i suppose that can not be the reason

tresB — Thu, 17 Sep 2015 12:54:00 GMT

If you could share your sample qvw, all this guessed suggetions could be avoided and could be hit the target directly.

curiousfellow — Thu, 17 Sep 2015 13:14:11 GMT

Trseco is right of course. So I herewith enclose an example

tresB — Fri, 18 Sep 2015 05:29:15 GMT

Rather use set analysis in the expression to limit the values in dimension. Let the second dimension be: periode and try expression:

=sum({<periodkeuze=,periode={'<$(gekozen_periode)'}>}value)

PFA