topic Where Expression Using Conditions on Two Fields in QlikView

Where Expression Using Conditions on Two Fields

Thu, 01 Nov 2012 15:30:39 GMT

I'm trying to create a variant on the following which also filters qICost_standard04 on cSource in the second two clauses.

=-(sum( {$<cSource = {'OP'}>} qTotalFCost )
+
Sum( {$<cCategory = {'Direct'}>} qICost_standard04 )
+
Sum( {$<cCategory = {'Indirect'}>} qICost_standard04 ))

In SQL I would just use

SELECT qICost_standard04

WHERE cCategory = 'Direct'

AND cSource = 'OP'

Have tried assorted variations of brackets and <> and just becoming frustrated.

Any help would be much appreciated.

Cheers

Geoff

Re: Where Expression Using Conditions on Two Fields

Gysbert_Wassenaar — Thu, 01 Nov 2012 15:39:08 GMT

try: Sum( {$<cSource = {'OP'}, cCategory = {'Direct'}>} qICost_standard04 )

to get the sum of qlCost_standard04 where cSource = 'OP' and cCategory = 'Direct'

cCategory = {'Direct','Indirect'} is the selector for the sql equivalent cCategory in ('Direct','Indirect')

Re: Where Expression Using Conditions on Two Fields

Thu, 01 Nov 2012 16:20:42 GMT

Cool, sorted thanks Gysbert