# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for
Did you mean:
Creator II

## Load specific data in qliksense table

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.

Labels (2)

• ### Set Analysis

1 Solution

Accepted Solutions
MVP

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:
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.

9 Replies
MVP

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

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

Creator II
Author

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.

MVP

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

Partner - Master III

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

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

Creator II
Author

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.

Partner - Master III

will you be able to share sample app

Specialist II

test:
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*')

MVP

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:
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.

Creator II
Author

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

Tags
Community Browser