Could I make 3 table without relation

[lichang422]

I made 3 tables and resource is from the same data.

Table 1(CNC Status) : Filter the SimpleSignalName = FAN , Bat , Act ....etc

Table 2(Servo Status) : Filter the SimpleSignalName = Amp , Zero , Temp ....etc

Table 3(Spindle Status) : Filter the SimpleSignalName = Spindle , spd  ....etc

Original , I think 3 tables are without relation ,When I select someone in table 1

Table 2 and Table 3 data are disapointed.

Maybe you will ask why i don't select at making table,Because I want to make some default data to support customer to select.

So how could i make it without relation??

[petter]

Thanks.

Shouldn't there be two more loads for Servo and Spindle too?

And it is very important that there is a

QUALIFY *;

Before the first LOAD statement. If the qualify statement is missing Qlik Sense will merge the three tables into one since all the field names will be similar. With the qualify statement each field will have the fieldname as a prefix thus making the three tables independent (not related)/unassociated).

[lichang422 · Accepted solution]

Oh, MY GOD .

I got it.

Thank you for answering my question so patiently ,Petter

Finally, My result code like below :

QUALIFY *;

[CNC]:

LOAD

   [L1Name],

   [signalname],

   [value],

   [SimpleSignalName]

RESIDENT [L1Signal_Pool_Active] WHERE   WildMatch(SimpleSignalName, '*sig*','*pro*','*comment*','*modal*','*parts*','*time*','*cnc*','*emg*','*mode*','*seq*');

[SV]:

LOAD

   [L1Name],

   [signalname],

   [value],

   [SimpleSignalName]

RESIDENT [L1Signal_Pool_Active] WHERE WildMatch(SimpleSignalName, '*servo*','*pos*','*pulse*','*zero*','*srv*','*apc*');

[SP]:

LOAD

   [L1Name],

   [signalname],

   [value],

   [SimpleSignalName]

RESIDENT [L1Signal_Pool_Active] WHERE WildMatch(SimpleSignalName, '*spdl*','*spindle*','*acts*','*sigenb*');