topic Re: Where clause in expression in QlikView

Where clause in expression

Tue, 08 Oct 2013 18:36:00 GMT

Hi,

I have the following expression in a table that returns values based on the entire data set. What is the correct method to limit the data to particular areas?

Original Expression:

=ceil([Refund Count]/([Closed Call]+[Closed Email])

,.001)

I need to be able to add a where clause to this expression to limit values and the calculation to look at a particular product of 'ABC'

How can this be accomplished?

Thanks

Re: Where clause in expression

israrkhan — Tue, 08 Oct 2013 18:44:53 GMT

hi Luke

try below expression

=ceil({<Product = {'ABC'} >} [Refund Count]/([Closed Call]+[Closed Email]),.001)

Product ={'ABC'} is your where clause.

Hope it helps

Re: Where clause in expression

Gysbert_Wassenaar — Tue, 08 Oct 2013 18:52:07 GMT

It's not clear if Refund Count, Closed Call and Closed Email are field names or column labels. If they are field names you can use something like:

=ceil(only({<Product={'ABC'}>}[Refund Count])/(only({<Product={'ABC'}>}[Closed Call])+only({<Product={'ABC'}>}[Closed Email])),.001)

Replace Product with the name of your product field.

If you used column labels of expressions in your expression that you'll have to add the set modifier {<Product={'ABC'}>} to the aggregation functions in those expressions.

Re: Where clause in expression

felipe_dutra — Tue, 08 Oct 2013 18:52:30 GMT

Hi!

Try this:

ceil

(

Sum

(

{<Product = {'ABC'}>}

[Refund Count]/([Closed Call]+[Closed Email])

)

,.001

)