sold product names

[manoj217]

Hi, i want to show sold product names instead of sum(sales) how to achieve that

[Anil_Babu_Samineni]

Simply, This won't useful to reply. I would write

Sum({<Product {'Sold'}>} Sales)

[manoj217]

i have the data Like this

Load * inline [product,salesamount,category

a,100,vol

b,200,vol

c,100,vol

d,200,err

e,200,ett

f,0,ery

r,0,rr];

here i want to show the records a to e because it have saleamount but f and r doesn't have so i want to show those values a b c d e as a output how?

[Anil_Babu_Samineni]

May be this?

Sum({<salesamount = {'>0'}>} salesamount)

OR

Sum({<salesamount = {"=Sum(salesammount)>0"}>} salesamount)

[its_anandrjs]

Try this

Sum({<salesamount = {"$(=Len(salesammount) > 0 )"}>} salesamount)

Or

Sum({<salesamount = {"$(=Len(salesammount) -= 0 )"}>} salesamount)

Or

Sum({<salesamount = {"$(=Sum(salesammount) > 0)"}>} salesamount)

Or

Sum({<salesamount = {"$(=Sum(salesammount) -= 0 )"}>} salesamount)

[sunny_talwar]

In a list box object? You can try this

Aggr(Only({1<product = {"=Sum(salesamount) > 0"}>} product), product)

[sunny_talwar]

Or this

=Aggr(Only({1<product = {"=Sum({<product>}salesamount) > 0"}>} product), product)

[MarcoWedel]

Hi,

Please review your open threads and close those who received correct answers:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

[vishsaggi]

Or may be this:

Load *, IF(salesamount > 0, 1, 0) as Salesflag inline [product,salesamount,category

a,100,vol

b,200,vol

c,100,vol

d,200,err

e,200,ett

f,0,ery

r,0,rr];

Create straight table with product and category as Dimensions.

Expr: = Sum({<Salesflag = {1} >}salesamount)