expression for getting top 5 other brands shopped when we select a brand

[#1]

Hi, I am trying to get the top 5 other brands shopped when i Qlik on one brand, expression is working when used in Dashboard but the same is not working when used in N printing dash board: below is the exp i am using:

In N printing dash board:

Sum ({<[Item.Brand Name] ={'*'} - {"$(vCurrBrand)"},  [IO.Order Guid]=P({<[Item.Brand Name]={"$(vCurrBrand)"}>})>}  IO.Quantity)

In customer dash board:

Sum ({<[Brand Name] ={'*'} - {"$(vCurrBrand)"},  [IO.Order Guid]=P({<[Brand Name]={"$(vCurrBrand)"}>})>}  IO.Quantity)

Dimension is Item.Brand Name in Nprinting DB

And just Brand Name in customer DB.

Thanks

[sunny_talwar]

nPrinting dashboard? Is it a separate QlikView file just used for nPrinting purposes?

[#3]

Hi Sunny , sorry for the delay in responding, actually i sorted it out, it was the variable which was creating problem. And yes that's nPrinting Dashboard.

Have an issue today, is there any automated process which can copy the recipients from one nPrinting (.nsq) file to another File.

Appreciate your contribution Sunny

Regards