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: 
manoj217
Creator III
Creator III

sold product names

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

8 Replies
Anil_Babu_Samineni

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

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
manoj217
Creator III
Creator III
Author

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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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)

Capture.PNG

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
Champion III
Champion III

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)

Capture.PNG