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: 
soniasweety
Master
Master

region wise

Hi all,

Ruben Marin

i want to show in pivot table top5 customers by each region

i have 3 regions  --- so in pivot table i want to show  total 15 customers each region 5 customers.

how can i do this?

Thanks

Sony

16 Replies
soniasweety
Master
Master
Author

its not working in my case chk the attachment

tresesco

pooja.prabhu.n

jyothish8807

Ruben Marin

rubenmarin

Hi sony, as Pooja saids below, if you have different expressions, those differenct expression are the ones showing other customers, try adding the same condition to all expresions. PFA.

You can check supress null values in dimension to remove the null value.

soniasweety
Master
Master
Author

sorry  ...

Ruben Marin

if i add customername in  the dimension it is giving me wronfg result..

check the attached.

actual requirment   region should not be in table

dim: accountname

salestage

jyothish8807
Master II
Master II

Hi Sony,

Try this:

=If(Aggr(Rank(Sum(Value)),Region,Account_Name)<7,Sum(Value))

Also refer the attached.

Br,

KC

Best Regards,
KC
soniasweety
Master
Master
Author

but... i want to see the service amount and hardware amount as a measures also

jyothish8807
Master II
Master II

Just copy the same expression and replace you expression for service and hardware

Refer the attachment.

Best Regards,
KC
rubenmarin

Hi Sony, Jyothish answer above is working, isn't?