topic Re: Need to show count from different tables ,filed name is same values are different in App Development

Need to show count from different tables ,filed name is same values are different

MS90 — Fri, 15 Nov 2024 21:53:04 GMT

Table a:

Load

Keyfield,

Name;

Table b:

Load

Keyfield,

Name;

Table c:

Keyfield,

Name;

Table d:

Keyfield,

Name;

Need to show count of field -Name(values are different)

Re: Need to show count from different tables ,filed name is same values are different

edwin — Thu, 20 Apr 2023 18:00:19 GMT

you need to show what your source data is and what you expect the output to be.
the script above will not work and its hard to understand just by looking at your script what you are trying to do

Re: Need to show count from different tables ,filed name is same values are different

MS90 — Fri, 21 Apr 2023 10:09:53 GMT

Below is the Script &expected output and source data image uploaded.

Table a:

Load

Keyfield,

Name;

Table b:

Load

Keyfield,

Name;

Table c:

Keyfield,

Name;

Table d:

Keyfield,

Name;

Need to show count of field

Re: Need to show count from different tables ,filed name is same values are different

Sabrina_V — Fri, 21 Apr 2023 14:42:10 GMT

A solution would be to concatenate all the tables.

Re: Need to show count from different tables ,filed name is same values are different

edwin — Fri, 21 Apr 2023 19:04:23 GMT

i agree with Sabrina, however, you have a more fundamental problem, your script is wrong you must have a source - thats really what you need to fix. concatenation will come naturally - Qlik will automatically concatenate these tables. however having said that, i would still explicitly concatenate them.

Re: Need to show count from different tables ,filed name is same values are differen...

Prem0212 — Mon, 24 Apr 2023 06:58:15 GMT

even if the fields name are same with different values in it we can get the count of field from different tables

Re: Need to show count from different tables ,filed name is same values are differen...

Prem0212 — Mon, 24 Apr 2023 07:02:44 GMT

in the above image we can use the fields from specific table and insert them by selecting the required table and field

Re: Need to show count from different tables ,filed name is same values are different

Prem0212 — Mon, 24 Apr 2023 07:05:07 GMT

and other method is that we can use the concatenate function then all the no of rows will be appended