Function in If

[mukesh19]

Hi all,

I have a small problem in the aggregation function  that is if I am using the below query I am not able to get the answer

count({< $(=upper(column1))={'SAMPLE'}>}   result)

The column1 has values in different cases(sample,Sample,SAMPLE,SAMple).In each and every case I require the result.

I know that I can use comma seperator as  count({< column1={'SAMPLE','sample','Sample','SAMple'}>}   result)

to achieve the result but there  may be n cases. Is there any direct method to achieve this.

can u guys help to solve the problem.

regards,

mukesh..

[sunny_talwar · Accepted solution]

Here try this

Count({<column1 = {"=Upper(column1) = 'SAMPLE'"}>} result)

But i think in the future anything between the double quotes with be case insensitive....

Quotes in Set Analysis

[mukesh19]

Can you please explain how it works

[sunny_talwar]

Anything between the double quotes is a search string and it usually works like this

Select all those column1s which gives true for this condition

=Upper(column1) = 'SAMPLE'

So, all those SAMPLE, Sample, sample, SAMple, etc will give true here

[mukesh19]

Count({<column1 = {"=Upper(column1) = 'SAMPLE'"}>} result)

What will be the value assigned to the column1 in the above expression

[sunny_talwar]

So think of this as straight table...

Dimension

column1

Expression

=Upper(column1) = 'SAMPLE'

Now if you uncheck 'Suppress Zero Value' on the presentation tab... all those rows where column1 = -1 will be the ones that show up for your expression