Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Counting a comparison between SUM and COUNT Expression

Hi,
I've the foloowing problem.

I've a table with "Target" and "Sell" values divided by Seller and By Category

SellerCategory

Cat 01

Cat 02Total
Seller 01Sell101222

Target151025
Seller 02Sell5611

Target5510

I would like to add a column (or row) saing How many target has been reached.
I found  that I could add "Target Reach" with "If (Sell>target, 1, 0)" is working for the Cats columns, but not for the Total (the one I really need)

Please note that Sell  = COUNT(ContractNr), and Target = SUM(Target)

Any idea?

Thank you

2 Replies
Not applicable

Re: Counting a comparison between SUM and COUNT Expression

Sorry I forgto to add...

the results for Seller01 should then be 0, 1, 1
for Seller 02 1, 1, 2

multiview
Contributor II

Re: Counting a comparison between SUM and COUNT Expression

I'd recommend you upload sample data and files. It makes understanding the problem easier!

Regards

MultiView

Community Browser