topic Re: Pls help in QlikView

Pls help

Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 30 Mar 2017 06:21:53 GMT

Hi,

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

[father's name]

Thu, 30 Mar 2017 06:26:25 GMT

Yes I tried same thing before

Even though, Its not reading properly.

tresB — Thu, 30 Mar 2017 06:27:59 GMT

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

Anil_Babu_Samineni — Thu, 30 Mar 2017 06:29:51 GMT

May be this? [father's name]

avinashelite — Thu, 30 Mar 2017 06:32:38 GMT

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

Thu, 30 Mar 2017 06:40:32 GMT

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

tresB — Thu, 30 Mar 2017 06:49:23 GMT

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.