Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write expression in Pivot table

Hi,

I need to get the values of Amount when

Amount>0 and Domain='RR' and Type in ('old',New') and ID=56432

here Amount,Domain,Type are from Sales table where ID is from Account table.

could anyone help me please how to write expression to get Amount.

Thanks.

13 Replies
jcoggon
Partner
Partner

Could you maybe explain a little more what you are trying to do or upload a sample app.

Not applicable
Author

Thanks and will the same works for Amount instead of Sum(Amount)?

MK_QSL
MVP
MVP

It's so simple still confusing. Could you pleas upload file ?

thomaswrieck
Partner
Partner

Not really clear what you would like to achieve ...

If you just want to sum up Amount matching your criteria you could use :

sum( {<Domain={'RR'}, Type={'old', 'new'}, ID={1}>} Amount)

Here, there's no need to exclude 0 amounts ...

If you just want to show data in a table matching your criteria, the only thing i could get to work is using a bookmark.

Just check the qvw ... and choose the available bookmark ...

it has been created by using a search box and entering the following :

=Amount<>0 and ID=1 and (Type='new' or Type='old') and Domain='RR'

Then hit enter and save this as a bookmark.