Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser22
Creator II
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.

Please help.  I would like have any set expression. 

Labels (2)
1 Solution

Accepted Solutions
Or
MVP
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:
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 ',');

Or_1-1641124994979.png

 

This appears to be exactly what you said you want.

View solution in original post

9 Replies
Or
MVP
MVP

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

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

qlikuser22
Creator II
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.

 

Thanks in advance.

Or
MVP
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.

shraddha_g
Partner - Master III
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

qlikuser22
Creator II
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. 

 

shraddha_g
Partner - Master III
Partner - Master III

will you be able to share sample app

anat
Master
Master

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
MVP
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:
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 ',');

Or_1-1641124994979.png

 

This appears to be exactly what you said you want.

qlikuser22
Creator II
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