Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Suppress Calculation of Qty

Hi,

I am attempting to create a list of customer's special prices, the quantity they need to purchase and the quantity that they have purchased since they received their special price.

I have made a straight table chart to produce the attached image, in it there are two lines of 300 meaning the customer has purchased 600 units - In total the customer has only ordered 300 units. Is there a way to suppress the qty expression until the last record is found?

Regards

David

2 Replies
Highlighted
Master II
Master II

Hi,

can u share the expression that u r using this chart.

you can also try to exclude null in below ways

Suppress null value in your customer ID dimension

or try to exclude using set analysis

sum( {$<CustomerID={"=len(trim(CustomerID))>0"}>} OrderQty)

Highlighted
Contributor
Contributor

Hi,

My expression is - Sum (if ([Starting Date]>= Date,[Quantity]))

Regards

David