Filter cases

[Anonymous]

Hello all,

Im fairly new to QlikSense and therefore I have a question I hope you can help me with.

I have 2 data sheets containing cases with various information - one with 60 and another with with 400.

I kinda want to combine all the information on all the cases from "datasheet 1" which has estimated 60 cases.
The datasheet 2 has around 3000 cases, but im only interested with the information for the 60 cases from datasheet 1.

There is a unique number that identifies them (but they are called something differently in each sheet.)

Is there a way I can combine the information?

I want want to build the following:

- "KPI" on count on number of cases (=60)

- "Bar chart" showing the count of cases pr month (from Okt. 2017 til feb 2018)

- "Bar chart" showing the failure codes

- "pie chart" showing the if the cases are warranty or on service contact.

datasheet 1: counting 60 cases

"Unique number"

"Hardware failure code"

datasheet 2: count 400

"Unique number"

"Warranty"

"Service contract"

"Paid service"

Thank you so much in advance !

Best regards Henrik.

[shilpan]

Hi Henrik, I hope that I understand what you want. When you load data, add a flag that indicates datasheet. So, you can use Set Analysis expression with a modifier like {<source={'Datasheet1'}>} for calculation if you want to include only records from datahseet1.

[karthikoffi27se]

Hi Henrik,

Yes, you can build all of the following. Please concatenate 2 tables and use the key flag to identify the difference in the data.

Many Thanks

Karthik

[Anonymous]

Alright so I have 2 data sheets.

But you guys talks about "flags", `but how do I add those?

I have tried to attach 2 excel sheets (table 1 and table 2).

Both of them has "PSR numbers" in the first column, but then the second column is different.

Furthermore the first excel sheet (table 1) has 5 "psr numbers" while the second excel sheet (table 2) has 20 "psr numbers"

In my QlikSense App, i only wanna see the 5 psr numbers but have access to both the linetype from table 1 and country from table 2.

The 2 data sources:

Table 1:

PSR Numbers: 5 numberes totabel

Linetype: warranty, service contract or service bill.

Table 2

PSR Numbers: 20 numbers total

Country: Denmark, Germany or Norway

QlikSense App:

Bar chart:

Dimension: Country

Measure: PSR numbers (5 psr numbers total - from table 1)

Pie chart:

Dimension: Linetype

Measure: PSR numbers (5 psr numbers total - from table 1)