topic Re: How to Display >=10 Values in Pivot Table Column? in QlikView

How to Display >=10 Values in Pivot Table Column?

khasimvali85 — Tue, 22 Jul 2014 08:12:41 GMT

Hi,

Any one Can Help me How to Display >10 Values in Pivot Table Column

my out put is

No.of Calls Call No >10 Calls

10 9966210476,9866210231 5,5

7 9876747466,7853464773 4,3

Re: How to Display >=10 Values in Pivot Table Column?

ali_hijazi — Tue, 22 Jul 2014 08:14:04 GMT

use rank function

for example

if your expression is Count(Calls)

then sum( {< call_id={"rank(Count(Calls),4) <=10"}>} aggr(count(Calls),Call_id))

Re: How to Display >=10 Values in Pivot Table Column?

MK_QSL — Tue, 22 Jul 2014 08:26:20 GMT

What do you mean by >10 values? Unclear from your sample also.

Re: How to Display >=10 Values in Pivot Table Column?

khasimvali85 — Tue, 22 Jul 2014 08:34:43 GMT

hi,

its Not working

Thanks,

Khasim.

Re: How to Display >=10 Values in Pivot Table Column?

khasimvali85 — Tue, 22 Jul 2014 08:40:48 GMT

Hi ,

For Examplae i have Calls like

i Want to Display like

Calls >10 Calls Red

15 10,5

19 10,5,4

13 10,3

17 10,4,2,1

22 10,10,2

above table >=10 calls should be Show in Red Color

Thanks,

Khasim.

Re: How to Display >=10 Values in Pivot Table Column?

MK_QSL — Tue, 22 Jul 2014 08:42:05 GMT

Can you provide some sample files? It's difficult to work on your sample..

Re: How to Display >=10 Values in Pivot Table Column?

aveeeeeee7en — Tue, 22 Jul 2014 09:41:01 GMT

You can color single cells for single value based on the condition to be add in Background color.

eg. if(Sum(Expression)>=10,Red(),Black())

But you have used concatenation function using delimeter ','

Regards

Aviral Nag

Re: How to Display >=10 Values in Pivot Table Column?

khasimvali85 — Tue, 22 Jul 2014 10:10:21 GMT

Hi,

I used Same Condition but its showing All are Red

Thanks for Suggession

Thanks,

Khasim

Re: How to Display >=10 Values in Pivot Table Column?

juleshartley — Tue, 22 Jul 2014 10:19:29 GMT

As Aviral mentioned, you cannot use this kind of logic on a concatenated (string) field.

You will need to split the cells out onto their own lines using something like a pivot table, and then apply the cell background formatting.

Re: How to Display >=10 Values in Pivot Table Column?

avinashelite — Tue, 22 Jul 2014 10:20:23 GMT

Try like this : if(call>='10',red(),Green())

If u face any issue please post your app

Re: How to Display >=10 Values in Pivot Table Column?

aveeeeeee7en — Tue, 22 Jul 2014 10:23:50 GMT

Sorry,

Try changing your Background Color Expression to:

=if(Sum(Expression)>=10,Red(),Black())

Re: How to Display >=10 Values in Pivot Table Column?

khasimvali85 — Tue, 22 Jul 2014 11:24:51 GMT

Hi,

I used Same Expression but Showing total row is Red

i need only >10 Calls only Red

Thanks,

Khasim.

Re: How to Display >=10 Values in Pivot Table Column?

juleshartley — Tue, 22 Jul 2014 12:48:16 GMT

It would help if you could post a sample app as we cannot see the problem...

Re: How to Display >=10 Values in Pivot Table Column?

khasimvali85 — Wed, 23 Jul 2014 06:55:19 GMT

Hi Julian,

I traied Somany Expressions but i didn't get Actual,

i want final out put is given below Screen, in this >3 Reminder Calls Column i want to display >3 value is RED

Ex: 1,2,2,2,5,7,8

Above Example i want to display 5,7,8 is show RED

you have any idea give me Suggession

Thanks,

Khasim.

Re: How to Display >=10 Values in Pivot Table Column?

perumal_41 — Wed, 23 Jul 2014 07:05:16 GMT

Try changing your Background Color Expression to:

=if(Sum(Expression)>=10 and not Dimensionality()=0 ,Red(),Black())

Re: How to Display >=10 Values in Pivot Table Column?

khasimvali85 — Wed, 23 Jul 2014 07:12:01 GMT

Hi,

Expression Means Which one?

Re: How to Display >=10 Values in Pivot Table Column?

perumal_41 — Wed, 23 Jul 2014 07:15:32 GMT

Backgroud expression

Re: Re: How to Display >=10 Values in Pivot Table Column?

perumal_41 — Wed, 23 Jul 2014 07:18:42 GMT

background expression

Re: How to Display >=10 Values in Pivot Table Column?

khasimvali85 — Wed, 23 Jul 2014 07:19:26 GMT

Hi Perumal,

I used This Expression

if(Concat({<ReminderDate= >}RemComplaintNo,';')>=4 and not Dimensionality()=0, Red(),Black())

but it showing total values are Red

Re: How to Display >=10 Values in Pivot Table Column?

khasimvali85 — Wed, 23 Jul 2014 07:21:11 GMT

Hi Perumal,

If We give in Back Ground Expression it shows Total Column Background is Red right?