topic Re: A very challenging requirement using set analysis ? in QlikView

A very challenging requirement using set analysis ?

swarup_malli — Tue, 25 Oct 2011 20:50:18 GMT

Hi!

i have a requirement , where i have to write a set expression with the requirments given below

where

i have to find the sum of donations by employee ,

- with distinct account numbers ( field name is indacctno)

- exclude account number starting with zero

- where totaldonation > 0 ( field name is totaldonation ) in a year ( year is a field)

this is what i have written , now i have to implement the above requiremnts in the expression given below .

sum ({$<CAMPAIGNTYPE ={'Empl'}>} DCDetails.TOTALDONATION)

Regards

Swarup

Re: A very challenging requirement using set analysis ?

Thu, 27 Oct 2011 11:49:59 GMT

Hi Swarup,

I have attached a sample file which I hope provides you with a solution - the chart highlighted in "blue" in the bottom right reflects the correct results & total per my understanding of the problem.

The expression I used for the TotalDonations is as follows:

=sum({<indacctno -= {"= Match (left (indacctno,1), '0')"}, campaigntype={'Empl'}>} totaldonation)

For others who may read this post please note how 'value' must be surrounded by {} when used in a set expression e.g. {'Empl'}

BUT not if the 'value' is used inside a double-quote "statement..." e.g. "= ....., '0')" per above. There are no {} around the '0'

Hope this helps.

Cheers,

Craig

A very challenging requirement using set analysis ?

swarup_malli — Thu, 27 Oct 2011 14:16:47 GMT

Hi Craig,

Thank you for helping me out.

Regards

Swarup