Compound filter

[luisccmm]

From the following post from    swuehl‌

Compound Search - demystified

I was wondering how those  STAR filfers "*" can be applied to SET ANALYSIS.

Specially the one that match the following example from that post

• AND operator '&'
  Using this operator, your compound search will return values that match both first and second search, obviously, this does only make sense if you are using wildcards:

I tryed to use the following filter for SALES MEASURE, but it din´t work.

SUM ({<DIMENSION1={"*New*&*rk*"}>} SALES)

Can any one help me that? Expected filter result is as the one provided above. Just filter strings that have both New and rk at the same time. Please only provide Qlik Sense Set Analysis solutions, I can´t wiew Qlik view apps, thanks.

[sunny_talwar]

Have you tried this?

Sum({<DIMENSION1 = {"*New*rk*"}>} SALES)

[luisccmm]

Thanks but it didn´t work as well.

[sunny_talwar · Accepted solution]

Let's take a very simple example here

Table:

LOAD * INLINE [

    Text, Sales

    Airport Newark, 50

    New York, 20

    Dallas, 36

    IGI, 12

];

When I used this

Sum({<Text = {"*New*rk*"}>} Sales)

I see this

=

Is this not what you wanted to see?

[luisccmm]

The problem I had in my data was cause for a  different order in the filter

To be more clear, using the same information in your example, what do not work is the following.

Sum({<Text = {"*rk*New*"}>} Sales)

But the following you are right, it does work.

Sum({<Text = {"*New*rk*"}>} Sales)

Thanks for your help stalwar1‌

[sunny_talwar]

Is there a reason you wanted to use Sum({<Text = {"*rk*New*"}>} Sales)?