Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

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

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)
Highlighted
Creator III
Creator III

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?

Highlighted

May be this?

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

OR

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

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)
Highlighted

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)


Highlighted

In a list box object? You can try this

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

Highlighted

Or this

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

Capture.PNG

Highlighted

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

Highlighted
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