New to Qlik Sense

[qlikuser22]

Hi

I have a table with data

CustNo    Name    Country

AB12         Rohan   USA

AB11         Anders   UK

ABC11      Johan   Denmark

ABC123    Peter     Sweden

XY12          Robert   France

XYZ123     Jon         USA 

I want one table with all data, and one more table which displays only AB*(AB12,AB11,ABC11,ABC123).

I need a sheet one which displays only AB* details and their corresponding graphs. The second sheet with all the data and the other visualizations.

Please help.  I would like have any set expression. 

[Or]

For all of the measures in the second sheet, you would use e.g.

Count({< CustNo = {"AB*"} >} Country)

[qlikuser22]

Thanks for the reply. This works perfect for the table.

But I have a measure like sum([Total Billing]) * $(vL.ConAmt) which indicates the total Billing KPI.

I tried something like sum({$< CustNo={"AB*"}>} [Total Billing] )* $(vL.ConAmt) and it doesn't work by filtering only AB*

Any suggestions.

Thanks in advance.

[Or]

No idea what's in the variable. You'll probably have to replace it with a variable that also has the correct set analysis.

[shraddha_g]

what is the expression used for $(vL.ConAmt)

you need to add same filter in the set expression used in the variable

[qlikuser22]

vl.ConAmt is a variable used to convert the billing based on currency. I tried something like this without a variable. sum({$< CustNo={"AB*"}>} [Total Billing] ). Even this isn't working. 

My idea is to use the same qvds and have 2 different sheets (one with CustNo = AB* and the next is full data)

In both the sheets I am using various KPI's, charts and tables.

Any suggestions. 

[shraddha_g]

will you be able to share sample app

[anat]

test:
load * Inline [
CustNo,Name,Country

AB12, Rohan,USA

AB11,Anders,UK

ABC11,Johan,Denmark

ABC123,Peter,Sweden

XY12,Robert,France

XYZ123,Jon,USA
](delimiter is ',');

Qualify *;
test1:
Load * Resident test where wildmatch(CustNo,'AB*')

[Or · Accepted solution]

This is working fine using the sample data you provided (except I had to add a Total Billing field because you didn't have one in your data):

test:
load * Inline [
CustNo,Name,Country, Total Billing

AB12, Rohan,USA, 10

AB11,Anders,UK, 20

ABC11,Johan,Denmark, 30

ABC123,Peter,Sweden, 40

XY12,Robert,France, 50

XYZ123,Jon,USA, 60
](delimiter is ',');

This appears to be exactly what you said you want.

[qlikuser22]

Thanks. It worked perfectly. I made mistake in brackets when writing set expression as I am very new to qliksense. Thanks a lot @Or