Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
khasimvali85
Creator II
Creator II

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


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

38 Replies
ali_hijazi
Partner - Master II
Partner - Master II

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))

I can walk on water when it freezes
MK_QSL
MVP
MVP

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

khasimvali85
Creator II
Creator II
Author

hi,

its Not working

Thanks,

Khasim.

khasimvali85
Creator II
Creator II
Author


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.

MK_QSL
MVP
MVP

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

aveeeeeee7en
Specialist III
Specialist III

Hi

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 ','

g.png

Regards

Aviral Nag

khasimvali85
Creator II
Creator II
Author

Hi,

I used Same Condition but its showing All are Red

Thanks for Suggession

Thanks,

Khasim

juleshartley
Specialist
Specialist

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.


avinashelite

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

If u face any issue please post your app