topic Re: Hide extra row in pivot table in QlikView

Hide extra row in pivot table

Anonymous — Wed, 13 Mar 2013 19:43:30 GMT

Hello,

I have field Browser with 8 tags.

I want show only IE, Chrome, Firefox, Safari.

I use my expression:

count({<[Browser]={'Chrome','Firefox','IE','Safari'}>}[Browser])/

count(TOTAL <MYear> [Browser])

It shows data only for my selections. How can I hide them?

I should use aggr function. Who can help me with idea?

Browser	MYear	Feb 2012	Mar 2012	Apr 2012	May 2012	Jun 2012	Jul 2012	Aug 2012	Sep 2012	Oct 2012	Nov 2012	Dec 2012	Jan 2013	Feb 2013
IE		59%	60%	63%	55%	61%	57%	56%	60%	58%	55%	59%	59%	53%
Chrome		17%	18%	15%	16%	14%	16%	17%	16%	18%	18%	20%	18%	22%
Firefox		18%	16%	16%	18%	18%	17%	19%	17%	17%	18%	14%	14%	17%
Safari		6%	6%	6%	10%	6%	9%	7%	7%	8%	8%	7%	8%	8%
AppleMAC-Safari		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
IEMobile		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Mozilla		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Opera		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%

Thanks,

Re: Hide extra row in pivot table

Wed, 13 Mar 2013 19:46:38 GMT

Hi,

Go to properties chart, sheet Presentation and uncheck Suppress Zero-values.

I hope will be helpfull.

Regards,

Ricardo

Re: Hide extra row in pivot table

Anonymous — Wed, 13 Mar 2013 19:51:34 GMT

Hello Ricardo,

It didn't help

Re: Hide extra row in pivot table

Wed, 13 Mar 2013 19:57:17 GMT

Share your app.

Re: Hide extra row in pivot table

er_mohit — Wed, 13 Mar 2013 20:04:59 GMT

count({$<[Browser]={'Chrome','Firefox','IE','Safari'}>}[Browser])/

count(TOTAL <MYear> [Browser])

count({<[Browser]={"$(='Chrome','Firefox','IE','Safari"}>}[Browser])/

count(TOTAL <MYear> [Browser])

Re: Hide extra row in pivot table

Anonymous — Wed, 13 Mar 2013 20:12:33 GMT

Please see attached file.

Re: Hide extra row in pivot table

Anonymous — Wed, 13 Mar 2013 20:13:36 GMT

I think only aggr function helps me.Please see attached file.

Re: Hide extra row in pivot table

Wed, 13 Mar 2013 20:23:50 GMT

Hi,

I built other table. Now it found. Check the attached.

Regards,

Ricardo

Re: Hide extra row in pivot table

Anonymous — Wed, 13 Mar 2013 20:35:24 GMT

Thanks,

Everything was correct.

I'm stuck with text color and font expressions.

Re: Hide extra row in pivot table

Wed, 13 Mar 2013 20:38:21 GMT

Hi,

I don't know, why your table has problems with the zero-values. Probably the if cause in "Text Color" and "Text Format" arte the problem.

Regards,

Ricardo

Re: Hide extra row in pivot table

Anonymous — Wed, 13 Mar 2013 20:42:08 GMT

I tried on your file. If I remove expression from text color and font, I got the same result.

My table is corrupt. Expressions in color and font compute all variants. (even if they not shown in table)

Re: Hide extra row in pivot table

rwunderlich — Thu, 14 Mar 2013 00:58:45 GMT

It looks like your Text and Background color expressions bring in the extra dim values, because you are not using the set modifier in those expressions. I believe you can simply the entire process by using a calculated dimension of:

=if(MixMatch([Browser],'Chrome','Firefox','IE','Safari'), [Browser])

and then your expression becomes simply:

count(Browser) / count(TOTAL <MYear> [Browser])

Seems to work for me. See attached.

-Rob

http://robwunderlich.com

Re: Hide extra row in pivot table

Anonymous — Thu, 14 Mar 2013 14:49:02 GMT

Thanks Rob.

You do miracles.

Re: Hide extra row in pivot table

Anonymous — Thu, 14 Mar 2013 15:15:21 GMT

Hi Rob,

I tried with other table. It didn't work, because it uses 100% just selected tags, not for all tags.

If(mixmatch(Field, 'A', 'B', 'C'),Field)

For example

A=55% A=45%

B=25% B=20%

C=20% C=15%

100% D=20%

100%

Thanks,