Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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
lichang422
Creator
Creator
Author

Sorry, I am not sure where is wrong.

It is difficult to me.

Can you help me to check where is missing.

未命名.jpg

未命名.jpg

未命名.jpg

petter
Partner
Partner

Each WildMatch(SimpleSignalName  has to be changed to

WildMatch(CNC.SimpleSignalName / WildMatch(Servo.SimpleSignalName / WildMatch(Spindle.SimpleSignalName

And the right tablename has to be specified at the end in the DROP TABLE statement - the same as in the three LOAD statements:

[L1Signal......514]      

lichang422
Creator
Creator
Author

Sorry, In the auto generate section,The content likes below :


Unqualify *;


[L1Signal_Pool_Active_temp_a9dd18a6-4dfe-37a6-c3c5-fb029afa]:

LOAD

[L1Name],

[signalname],

[value],

Replace([signalname],'_'&[L1Name],'') AS [SimpleSignalName]

RESIDENT [L1Signal_Pool_Active];

DROP TABLE [L1Signal_Pool_Active];


RENAME TABLE [L1Signal_Pool_Active_temp_a9dd18a6-4dfe-37a6-c3c5-fb029afa] to [L1Signal_Pool_Active];




So When I create a new section.

QUALIFY *;

[CNC]:

LOAD

[L1Name],

[signalname],

[value],

[SimpleSignalName]

FROM

[L1Signal_Pool_Active_temp_70ddf4c0-8c06-6a9b-b31e-5ea0adc3]

WHERE

  WildMatch(SimpleSignalName, '*sig*','*pro*','*comment*','*modal*','*parts*','*time*','*cnc*','*emg*','*mode*','*seq*');

UNQUALIFY *;

DROP TABLE [L1Signal_Pool_Active_temp_70ddf4c0-8c06-6a9b-b31e-5ea0adc3];



Should I need to change underline same as auto generate section ??

petter
Partner
Partner

Sorry - I was a bit too quick... the code should refer to the original table name like this in four different places:

QUALIFY *;

[CNC]:

LOAD

[L1Name],

[signalname],

[value],

[SimpleSignalName]

FROM

  [L1Signal_Pool_Active]

WHERE

  WildMatch(CNC.SimpleSignalName, '*sig*','*pro*','*comment*','*modal*','*parts*','*time*','*cnc*','*emg*','*mode*','*seq*');


[Servo]:

LOAD

[L1Name],

[signalname],

[value],

[SimpleSignalName]

FROM

  [L1Signal_Pool_Active]

WHERE

WildMatch(Servo.SimpleSignalName, '*servo*','*pos*','*pulse*','*zero*','*srv*','*apc*');

[Spindle]:

LOAD

[L1Name],

[signalname],

[value],

[SimpleSignalName]

FROM

  [L1Signal_Pool_Active]

WHERE

  WildMatch(Spindle.SimpleSignalName, '*spdl*','*spindle*','*acts*','*sigenb*');


UNQUALIFY *;

DROP TABLE [L1Signal_Pool_Active];

lichang422
Creator
Creator
Author

It is so terrible, I can't success it.

I had reduce sentence,But Alarm is still.

Can you help me again ?? Thank you!!

未命名.jpg

petter
Partner
Partner

My fault - I do some basic mistakes myself since I am "dry" coding here without having access to something I can verify...

You have to replace all FROM to RESIDENT for the three LOAD statements.


For the first one it would look like:

[CNC]:

LOAD

   [L1Name],

   [signalname],

   [value],

   [SimpleSignalName]

RESIDENT

  [L1Signal_Pool_Active]

WHERE

  WildMatch(CNC.SimpleSignalName, '*sig*','*pro*','*comment*','*modal*','*parts*','*time*','*cnc*','*emg*','*mode*','*seq*');


lichang422
Creator
Creator
Author

Sorry,When I directly copy your code to test.

It show like below.

未命名.jpg

So I re-code about WHERE parts like below

WHERE WildMatch('CNC.SimpleSignalName', '*sig*','*pro*','*comment*','*modal*','*parts*','*time*','*cnc*','*emg*','*mode*','*seq*');

It looks like success.

But I can't feel any different.

Is it right?

Or where i need to care ??

未命名.jpg

lichang422
Creator
Creator
Author

Hi,Petter

     Do you see my reply ? Does I modify it correctly ??

Why I can't see another bubble(like CNC bubble)

Or I mistake something ??

petter
Partner
Partner

Does the reload run successfully?

Can you share a screenshot of the Data Model Viewer ?

lichang422
Creator
Creator
Author

Sorry, I've been bothering you

未命名.jpg

未命名.jpg