Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

davidmcfall
New 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
devarasu07
Honored Contributor II

Re: Suppress Calculation of Qty

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
davidmcfall
New Contributor

Re: Suppress Calculation of Qty

Hi,

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

Regards

David