Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Karl_Hart
Creator
Creator

Wildmatch over multiple fields

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

12 Replies
sunny_talwar

So, I tried this

Table:

LOAD * INLINE [

    Dim, 2016, 2017

    A, 20, 40

    B, 30, 65

];

STORE Table into Table.qvd (qvd);

DROP Table Table;

Table:

CrossTable(Year, Value)

LOAD *

FROM Table.qvd (qvd);

Gave me this

Capture.PNG

While this worked without any issues

Table:

LOAD * INLINE [

    Dim, 2016, 2017

    A, 20, 40

    B, 30, 65

];

STORE Table into Table.qvd (qvd);

DROP Table Table;

Table:

CrossTable(Year, Value)

LOAD *

FROM Table.qvd (qvd)

Where 1 = 1;

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Yeah, orphans all over the place. You really don't want that in your data model.

Still the same as it used to be.

Karl_Hart
Creator
Creator
Author

Thank you, this worked perfectly