topic Adding more variables to set analysis in QlikView

Adding more variables to set analysis

Mon, 21 Sep 2009 08:47:23 GMT

Hi,

I have the below formula that says to include only sales with a value greater than 1 so to exclude any credits

sum({$<Sales>1>} Sales)

I want to know how to add more than one variable to the set analysis and include TL_Cust = 'M001' or TL_Cust = 'D001'.

e.g. I used to do:

sum(if(Sales >1 and TL_Cust = 'M001' or TLCust = 'D001',Sales))

How do I add this in set analysis

Thanks

Dave

Mon, 21 Sep 2009 12:46:19 GMT

Do you get correct results using your set

<pre>sum({$<Sales>1>} Sales)

I think, it should be something like this

sum( {$<Sales={"=Sales>1"},TL_Cust ={ 'M001','D001'}>} Sales)

Mon, 21 Sep 2009 12:52:14 GMT

Is it posible use greater in set analysis ?

I think use only equal ( = )

example)

=Sum ({$<Sales={1},TL_Cust={'M001','D001'}>} Sales)

Mon, 21 Sep 2009 13:17:46 GMT


Richy wrote:Do you get correct results using your set

Yes this set does work great, no problems with the > sign so far


Richy wrote:sum( {tiny_mce_markerlt;Sales={"=Sales>1"},TL_Cust ={ 'M001','D001'}>} Sales)

This also worked perfectly, Thanks!

David