topic Hide data on Dimension in QlikView

Hide data on Dimension

Mon, 26 Sep 2011 14:53:50 GMT

Dear all,

i have a problem and I don't know how to solve.

Take this example

NUMBER

DATA

VALUES

Imagine that we have data on table, but some values on field data are null.

Now, imagine that we create a pivot table with "NUMBER" as dimension and "SUM(VALUES)" as Expresion.

I want to hide al Number with data field empty without set "DATA" as Dimension.

It's possible.

Best regards.

Mon, 26 Sep 2011 15:01:53 GMT

Solved with a Calc dimension

if (isnull(DATA),Null(),NUMBER)

And check hide null data.

If you know best way, please let me know,

Mon, 26 Sep 2011 15:05:43 GMT

use set analysis

something like sum( {$<data={"*"}>} values )

Mon, 26 Sep 2011 15:16:46 GMT

It will be valid on that example.

But if I have more expressions, i have to put a set analysis on every expression, and I want to create pivot table without set analysis function.

I will try to check how many memory process needs.

Mon, 26 Sep 2011 15:48:54 GMT

in my experience is it better solution than IF statements.

but, try with your data and let me know