topic Re: hide part tags from dimension in QlikView

hide part tags from dimension

Anonymous — Fri, 25 Jan 2013 20:27:50 GMT

Hi,

I have chart. I want to show only A,B,D tags with them %.

If I use condition IF(Var1<>C and Var1<>E,Var1) in dimension, it shows % based on A,B,D.

If I use condition IF(Var1<>C and Var1<>E,count(Var1)) in expression, it shows % based on A,B,D. (the same as in dimension)

Thanks,

whiteline — Sun, 27 Jan 2013 12:50:59 GMT

Assume: dim1 = {A, B, C, D, E}, dim2 = {aa, bb, cc} and Value field for counting.

Create bar chart with dimenions dim1, dim2 and expression:

=Count({<dim1={A,B,C}>} value)/Count(total<dim2> Value)

Anonymous — Mon, 28 Jan 2013 15:34:33 GMT

Hi Whiteline,

My dim2 is not 1 variable.

I calculate so

My dimension: Var 1.

Expression:

1. Count({<[Var 3]=, [Var4]=>} [Value]) ------aa

2. Count({<[Var 3]=>} [Value]) ------bb

3. Count([Value]) -----cc

All 3 expression I checked Relative.

Regards,

whiteline — Sat, 02 Feb 2013 19:18:09 GMT

Ok, I thought there are two dims.

1) Uncheck realtive.

3) Use condition in set analysis instead (see below).

2) Calculate relative manually like this: =Count({<[Var 1]={A,B,C}>} [Value])/Count(total [Value]) etc.

Anonymous — Thu, 07 Feb 2013 16:16:41 GMT

Hello my fried.

Thanks, you're right. It works.