Qlik Community

New to Qlik Sense

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

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nani1618
Contributor
Contributor

Loading Data And Designing

Hi All,

I am loading 3 different QVDS  from same source with same field names but the data is different and I want to separate that date in UI how I can do that

3 Replies
ajaykakkar93
Specialist
Specialist

Hi,

While loading fields you can add another field on all qvds & then concat them together

Example

T1:

Load * ,

'table1' as TXn

From lib://.....qvd;

Concatenate(T1)

T2:

Load * ,

'table2' as TXn

From lib://.....qvd;

Concatenate(T1)

T3:

Load * ,

'table3' as TXn

From lib://.....qvd;

 

You will get a single table

Then in set analysis you can specify the specific tXn field value.

_armoco_
Partner - Creator II
Partner - Creator II

Hi,

You mentioned want to separate the 'date' or is it 'Data'...?

If I understand correct, then your data is getting auto concatenated as all the tables have same fields. You can separate it by forcing a 'Noconcatenate' but this will create a synthetic key issue. So instead create a flag field in all 3 loads:

A:

load

..., ...,...,'A' as Flag,...etc

from....;

B:

load

..., ...,...,'B' as Flag,...etc

from....;

C:

load

..., ...,...,'C' as Flag,...etc

from....;

Now in the front end you can use the flag to differentiate between data

Ex: Sum({<Flag={'A'}>}Amt)  //This will give data of Qty of table A as Flag A is created for table A

Sum({<Flag={'C'}>}Amt)  //This will give data of Qty of table C as Flag C is created for table C

Similarly, you can use it in if conditions too...

 

Regards,

Arjun

ajaykakkar93
Specialist
Specialist