Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
MS90
Creator
Creator

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

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)

 

Labels (4)
7 Replies
edwin
Master II
Master II

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

MS90
Creator
Creator
Author

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

Screenshot_20230421-153522~2.png

Table a:

Load 

 Keyfield,

Name;

Table b:

Load 

Keyfield,

Name;

Table c:

Keyfield,

Name;

Table d:

Keyfield,

Name;

Need to show count of field

Sabrina_V
Partner - Creator II
Partner - Creator II

A solution would be to concatenate all the tables.  

edwin
Master II
Master II

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.

Prem0212
Creator
Creator

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

Prem0212
Creator
Creator

Screenshot 2023-04-24 123040.png

 

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

Prem0212
Creator
Creator

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