Pls help

[#1]

Hi Viewers,

I have a situation on reading strings

I have a field called father's name now in front end I want count.

But its not reading properly

I tried with 'father's name' and

                "father's name" and

                 '(father's name)

and also need to use it in set analysis as well.

Any other suggestions ????

[karthiksrqv]

Hi,

If you have fields that include a 'space', you'd have to use square brackets to refer to such fields.

[father's name]

[#3]

Yes I tried same thing before

Even though, Its not reading properly.

[tresesco]

Could you share your sample app or at least a screen shot ?

[Anil_Babu_Samineni]

May be this? [father's name]

[avinashelite]

Could you share the sample data and the desire output ? so that we could help you on the same

[#7]

Dimension:

=ValueList('aadhar','pan','bank','father's name')

expression :

Pick(Match(ValueList('aadhar','pan','bank','father's name'),

'aadhar','pan','bank','father's name'),

Count(aadhar),Count(pan),Count(bank),count(father's name))

This is am trying to do pls help

[tresesco · Accepted solution]

Try like:

Dimension :

=ValueList('aadhar','pan','bank','father''s name')

expression :

Pick(Match(ValueList('aadhar','pan','bank','father''s name'),

'aadhar','pan','bank','father's name'),

Count(aadhar),Count(pan),Count(bank),count([father's name]))

Note: Red highlighted  quotes are two single quotes and not double quotes.