topic Re: How to hide some rows based of criteria resulting from a complex expression ? in QlikView

How to hide some rows based of criteria resulting from a complex expression ?

zarmoton — Fri, 29 Nov 2013 13:45:20 GMT

hello

I would like to hide some rows in a pivot table based on the result of differents columns in expression a bit complex.

like this example

thk you for your help

Regrads,

Re: How to hide some rows based of criteria resulting from a complex expression ?

marcus_sommer — Fri, 29 Nov 2013 16:15:42 GMT

In both columns must be a condition like:

if(IsNull(expression2012) or IsNull(expression2013), null(), expression2012)

and then hide null-values in tab presentation.

- Marcus

Re: How to hide some rows based of criteria resulting from a complex expression ?

Gysbert_Wassenaar — Fri, 29 Nov 2013 17:44:05 GMT

See attached qvw.

Re: How to hide some rows based of criteria resulting from a complex expression ?

Fri, 29 Nov 2013 21:09:35 GMT

gysbert - i love your solutions, you are very good - however sometimes it is not obvious to us rookies to see what you have done. Could you maybe write a small note on how you did it or why?

Just a future advice which could be nice if you adapted - Even though i know you already put a lot of work into it

Re: How to hide some rows based of criteria resulting from a complex expression ?

zarmoton — Mon, 02 Dec 2013 08:57:37 GMT

Hi Gysbert,

Thk you

But the attached file seems empty.

I don’t see my example with your correction

Thank you for your help

Regards,

Re: How to hide some rows based of criteria resulting from a complex expression ?

zarmoton — Mon, 02 Dec 2013 09:41:58 GMT

Hi Thomas,

Can you see something in the document proposed by Gysbert ?

Me, i see a blank document

If yes, can you copy/paste the solution/ (content of the expression) ?

thank you

Re: How to hide some rows based of criteria resulting from a complex expression ?

Mon, 02 Dec 2013 09:43:00 GMT

Nope its blank here also

Re: How to hide some rows based of criteria resulting from a complex expression ?

zarmoton — Mon, 02 Dec 2013 09:51:14 GMT

Thk you Marcus

I don't understand what do you propose, for me there is only one expression.
So how to apply that: if(IsNull(expression2012) or IsNull(expression2013), null(), expression2012)

can you try to open my qvw as example, and propose a solution ?

thk you for your help

Re: Re: How to hide some rows based of criteria resulting from a complex expression ?

marcus_sommer — Mon, 02 Dec 2013 11:09:18 GMT

My suggestion was more a general approach, but it always depend on the individual case. It's quite complicated to solve this with a single expression, but with two expressions it's quite easy - see the example.

- Marcus

Re: How to hide some rows based of criteria resulting from a complex expression ?

ljackson — Wed, 04 Dec 2013 15:02:55 GMT

Blank here too!