Wildmatch over multiple fields

[Karl_Hart]

I have the following expression in a text box.

=sum([NS D1 Desk])

+sum([NS D1 Facilities])

+sum([NS D1 Hours])

+sum([NS D1 HRBP])

+sum([NS D1 Induction])

+sum([NS D1 Inductionmeeting])

+sum([NS D1 Introduced])

+sum([NS D1 Login])

+sum([NS D1 ManualHandling])

+sum([NS D1 Officetour])

+sum([NS D1 Password])

+sum([NS D1 Reception])

+sum([NS D1 Uniform])

Is there a way to use a wildcard to have it something like

=sum([NS D1 *])

For reference, the data looks something like

Name          ND D1 Desk     NS D1 Facilities     NS D1 Hours .........

Adam               1                         0                              1

Betty                1                         1                              0   

Carl                  1                         1                              1                   

Denise              0                         0                              1

:

:

So the answer in this made up example would be sum([NS D1 *]) = 8

Thanks,

Karl

[prma7799]

Is there a way to use a wildcard to have it something like

=sum([NS D1 *])

I think No

[Anil_Babu_Samineni]

How come 8 it should 5, Right?

[Anil_Babu_Samineni]

May be this?

Cross:

CrossTable(Files, Data,1)

LOAD * Inline [

Name,          ND D1 Desk   ,  NS D1 Facilities  ,   NS D1 Hours , ND Real

Adam  ,             1           ,              0  ,                            1, 1

Betty  ,              1        ,                 1 ,                             0 , 2 

Carl    ,              1      ,                   1 ,                             1   , 3               

Denise   ,           0       ,                  0    ,                          1, 4

];

Output:

[sunny_talwar · Accepted solution]

One option would be to do something like this

Sum($(=Concat({<$Field = {"NS D1 *"}>} '[' & $Field & ']', '+')))

[Karl_Hart]

There was a typo in my original data, it should have said NS D1 Desk, but given that, yes 5 is the correct answer.

Can I do a Crosstable when loading from a QVD file?

[Peter_Cammaert]

Yes.

Make sure that your LOAD FROM QVD is unoptimized.

[sunny_talwar]

Hey Peter -

Why in optimized load creates issue with CrossTable? is this a bug or by design?

[Peter_Cammaert]

Hi Sunny,

it's probably something inbetween called "WAD" (Works as Designed) and I'm not inventing anything here; that's official Qlik R&D terminology. Reading Section Access data from a QVD using an optimised Load has the same problem.

Now that I think about it: I'm not sure whether thiese statements are still valid in v12.xx. Didn't test it in the latest releases. But better safe than sorry

Peter

[sunny_talwar]

I did a test on the v12 and it still seems to give me some weird output....So, I guess that this is still an issue