Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set Analysis Syntax

This does not work:

Count({$<RebateAmtReported={"=0"}>} DISTINCT TransactionID)

But this does:

Count({$<RebateAmtReported={"<>0"}>} DISTINCT TransactionID)

Why?

I'm trying to get a count of transactions w/rebates vs. transactions without rebates.

1 Reply
Highlighted
Not applicable

Set Analysis Syntax

This should work:

Count({$<RebateAmtReported={"0"}>} DISTINCT TransactionID)