Discussion Board for collaboration related to QlikView App Development.
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?
its not working in my case chk the attachment
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.
if i add customername in the dimension it is giving me wronfg result..
check the attached.
actual requirment region should not be in table
Also refer the attached.
but... i want to see the service amount and hardware amount as a measures also
Just copy the same expression and replace you expression for service and hardware
Refer the attachment.
Hi Sony, Jyothish answer above is working, isn't?