Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am hari. I am new to Qlikview. Could you please explain how to find top 6 sales in pivot table ?
Hi,
may be this
write in expression like this as per your fields
if(aggr(rank(sum(sales)),product)<=6,product)
for your reference