topic Could I make 3 table without relation in App Development

Could I make 3 table without relation

lichang422 — Mon, 22 Jan 2018 09:28:09 GMT

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

Re: Could I make 3 table without relation

petter — Mon, 22 Jan 2018 09:36:40 GMT

Can you tell us all of the names of the fields in each of the three tables?

Re: Could I make 3 table without relation

lichang422 — Mon, 22 Jan 2018 09:42:08 GMT

table 1 (CNC Status) expression :

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

),SimpleSignalName)

table 2 (Servo Status) expression :

=if(WildMatch(SimpleSignalName, '*servo*','*pos*','*pulse*','*zero*','*srv*','*apc*'

),SimpleSignalName)

Table 3 (Spindle Status) expression :

=if(WildMatch(SimpleSignalName, '*spdl*','*spindle*','*acts*','*sigenb*'

),SimpleSignalName)

They are all from SimpleSignalName data.

Re: Could I make 3 table without relation

petter — Mon, 22 Jan 2018 09:53:18 GMT

These are the expressions for the measures in your table in the UI.

I was asking about the field names of the three tables in you data model. They determine how the values in various fields are associated (related). Could you please give us the names of all the fields in the three tables. You can find them in the Data Model Viewer. Maybe you can make a screenshot of that and post it here?

Re: Could I make 3 table without relation

ericasense — Mon, 22 Jan 2018 09:57:35 GMT

Hi Shih, the way that the data engine in QlikSense works is that it automatically performs a join in the background on any two fields with exactly the same name.

Eg, if you have two unrelated tables, eg Sales and SafetyIncidents, but they both have a field called [Date], then QlikSense will connect those tables using the field [Date]. Selecting a value in SafetyIncident will filter that table, and then also filter sales for any matching dates.

The solution is to rename any fields that are the same. Easiest way to do this is to go into the data model viewer and look at the connecting lines between the tables, and which fields they are connecting, then go back into the script and rename those fields.

Alternately, you can use the Qualify statement to automatically prefix tablenames to the start of field names. Just type

Qualify *;

before any tables you wish this to apply to, and then after the table has loaded type

Unqualify *;

To ensure it doesn't get applied anywhere else. This will transform all fieldnames into the format Tablename.Fieldname

Erica

Re: Could I make 3 table without relation

lichang422 — Mon, 22 Jan 2018 10:08:53 GMT

I think i post my qvf , maybe it is quickly to let everyone know my proble

Thanks for everyone reply.

Re: Could I make 3 table without relation

ericasense — Mon, 22 Jan 2018 10:18:18 GMT

Hi Shih, not sure what this is telling me, there only seems to be one table loaded in there?

Are you getting confused between the fields and the tables? And did you want to split the table out into 3 tables, is that what you are trying to do?

Erica

Re: Could I make 3 table without relation

lichang422 — Mon, 22 Jan 2018 10:26:35 GMT

Yes, this is my problem.

I just only one table loaded.

I want to split it into 3 tables and 3 tables are not any relation(3 tables filters can be selected independly)

Why i don't want to load 3 times??

Because now this data is very small.In the future,the data will become very bigger .(More than 100 thousand)

So if i load 3 times ,it will spend a lot of time.

Re: Could I make 3 table without relation

ericasense — Mon, 22 Jan 2018 10:34:39 GMT

You could load one field each time from SQL?

SQL SELECT L1Name FROM MTLINKi.`L1Signal_Pool_Active`;

SQL SELECT signalname FROM MTLINKi.`L1Signal_Pool_Active`;

SQL SELECT value FROM MTLINKi.`L1Signal_Pool_Active`;

Erica

Re: Could I make 3 table without relation

petter — Mon, 22 Jan 2018 10:43:38 GMT

The quickest modification would be to do like this - by adding a new Section at the end of you load script:

I have attached the text also.

Re: Could I make 3 table without relation

lichang422 — Mon, 22 Jan 2018 11:11:13 GMT

Sorry, I am not sure where is wrong.

It is difficult to me.

Can you help me to check where is missing.

Re: Could I make 3 table without relation

petter — Mon, 22 Jan 2018 11:32:47 GMT

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]

Re: Could I make 3 table without relation

lichang422 — Mon, 22 Jan 2018 15:18:12 GMT

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

Re: Could I make 3 table without relation

petter — Mon, 22 Jan 2018 16:06:12 GMT

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];

Re: Could I make 3 table without relation

lichang422 — Tue, 23 Jan 2018 02:25:03 GMT

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

I had reduce sentence,But Alarm is still.

Can you help me again ?? Thank you!!

Re: Could I make 3 table without relation

petter — Tue, 23 Jan 2018 08:07:13 GMT

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

Re: Could I make 3 table without relation

lichang422 — Tue, 23 Jan 2018 10:49:21 GMT

Sorry,When I directly copy your code to test.

It show like below.

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

Re: Could I make 3 table without relation

lichang422 — Thu, 25 Jan 2018 01:51:21 GMT

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

Re: Could I make 3 table without relation

petter — Thu, 25 Jan 2018 07:11:19 GMT

Does the reload run successfully?

Can you share a screenshot of the Data Model Viewer ?

Re: Could I make 3 table without relation

lichang422 — Thu, 25 Jan 2018 07:20:39 GMT

Sorry, I've been bothering you