topic Re: Re: Calculation Condition Unfulfilled in QlikView

Calculation Condition Unfulfilled

Wed, 10 Sep 2014 14:42:25 GMT

I know this should be very simple, but I can't seem to crack it! How do I apply a simple calculated condition on a string value?

I want to filter CustomerID on the value of 'AAAAA' using the formula:

CustomerID = 'AAAAA'

Please see attached QV file and screenshot

Re: Calculation Condition Unfulfilled

jonathandienst — Wed, 10 Sep 2014 14:59:57 GMT

It works as designed - the condition is fulfilled when AAAAA is selected and the table box displays.

Perhaps you want to filter the data for the 'AAAAA's regardless of the selected value. Then you would need to use a straight table (not a table box) with Date as a dimension. Then use this expression:

=Sum({<CustomerID = {'AAAAA'}>} Amount)

HTH

Jonathan

Re: Re: Calculation Condition Unfulfilled

Wed, 10 Sep 2014 15:19:55 GMT

Thanks for that clarification, I didn't realize that the Conditional Expression only works on selected values.

I tried adding the straight table with the formula you suggested, but it still doesn't filter on the AAAAA records. Can you please take a look?

Re: Re: Re: Calculation Condition Unfulfilled

rubenmarin — Wed, 10 Sep 2014 15:45:26 GMT

Hi Carleton,

You can filter using set analysis, check the expression on file attached.