topic Re: Conditional hide rows in dimension in QlikView

Conditional hide rows in dimension

Thu, 05 Jun 2014 14:25:09 GMT

Hi all!

I'm newbie in QlikView and this is my first post.

The users requirement is as follows. We have two dimensions (concept 1 and concept2) in a pivot table chart. They want to hide the rows when the second dimension has only one occurrence, and keep the total in the first dimension:

Does anyone know any way to get it?

Thanks in advance!

Cheers,

Xavi F.

Re: Conditional hide rows in dimension

annafuksa1 — Thu, 05 Jun 2014 14:34:51 GMT

Hi, you need to use calculated dimension

please attach file with data.

Re: Conditional hide rows in dimension

Thu, 05 Jun 2014 14:41:58 GMT

What is actual result and expected result, are they concept1 and concept2? Can you provide some more explanation for your problem?

Re: Conditional hide rows in dimension

Thu, 05 Jun 2014 14:51:36 GMT

Is concept1 a count and concept2 a category?

Re: Conditional hide rows in dimension

Thu, 05 Jun 2014 15:43:21 GMT

ACTUAL RESULT is the result that I have at the moment.

Concept 1 and Concept 2 are two dimensions. Concept 1 is the first dimension (bold font style) and Concept 2 the second one (normal font):

SPECTED RESULT is that I want to get. I want to hide Concept 2 when it has only one row, i.e: Concept 1 'Machines and Accesories' has only one ocurrence in Concept 2, then I don't want it apears in the table. Concept 1 'ITIS' has two ocurrences in Concept 2 ('Hardware' and 'Maintenance'), then they sould be present in the table:

Re: Conditional hide rows in dimension

Thu, 05 Jun 2014 15:47:34 GMT

fieldvaluecount might be what you need.

So in your conditional expression for Concept1:

if(FieldValueCount(Concept2) > 1, 1, 0)

Re: Conditional hide rows in dimension

Thu, 05 Jun 2014 15:48:25 GMT

Here is the syntax for fieldvaluecount:

fieldvaluecount(fieldname)

Returns the number of distinct values in a field. Fieldname must be given as a string (e.g. a quoted literal).

Re: Re: Conditional hide rows in dimension

Tue, 10 Jun 2014 10:11:35 GMT

Hi Jacob,

Thaks for your answer.

I've been testing with FieldValueCount as you proposed and other functions (Count, Count Distinct, RowNo,...) and I did not get the expected result.

Can you explain it in more detail, please?

I attached the qvw file

Thanks!

Xavi F.

Re: Conditional hide rows in dimension

Fri, 13 Jun 2014 08:53:31 GMT

Hi all!

I have continued to test but I have not found the solution.

I created an expression that counts how many rows appear in DIM2 for each value of DIM1, but I can not use the same formula in the dimension definition (see attached qvw file).

Any suggestions?

Thanks!

Xavi F.