Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
lichang422
Creator
Creator

Could I make 3 table without relation

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

未命名.jpg

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

未命名.jpg


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??

未命名.jpg

21 Replies
petter
Partner - Champion III
Partner - Champion III

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
Creator
Creator
Author

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*');


未命名.jpg