Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

concatenate

Hi all,

Tresesco B

I have small confusion in data.

I have two tables and in botht the tables I have some fields as same and some other different fields.

my req is:  1.  one dashboard I need to show count of both values based on some field,

2. I want to show separate table count values.

how to show?

3 bas charts

example:

1.count of company both=18

in one report

2.count of mi =9

separate MI report

3.count of md=9

separate MD report

Tags (2)
1 Solution

Accepted Solutions
pathiqvd
Contributor III

Re: concatenate

Hi,

Try like this,

MI:

Load *,'MI' as Flag from MI_Table;

Concatenate

MD:

Load *,'MD' as Flag from MD_Table;


chart1:-  count({<Flag=>}Company)

chart2:-  count({<Flag={"MI"}>}Company)

chart3:-  count({<Flag={"MD"}>}Company)



Regards,

5 Replies
pathiqvd
Contributor III

Re: concatenate

Hi,

Try like this,

MI:

Load *,'MI' as Flag from MI_Table;

Concatenate

MD:

Load *,'MD' as Flag from MD_Table;


chart1:-  count({<Flag=>}Company)

chart2:-  count({<Flag={"MI"}>}Company)

chart3:-  count({<Flag={"MD"}>}Company)



Regards,

Re: concatenate

Hi,

You can do a simple concatenate like below.

Load *,'A' as Source from Table A;

Concatenate

Load *,'B' as Source from Table B;


For 1 Chart just count the Company.

For 2 Chart use set analysis to filter to source A

For 3 Chart use set analysis to filter to source B

Regards,

Kaushik Solanki

MVP
MVP

Re: concatenate

Try loading the tables like:

T1:

Load

          *,

          1 as flag

From <>;

Concatenate

Load

          *,

         2 as flag

From <>;

Now in the front-end,

Dim=Company

For All company report : =Count(Model)

For First table company report : =Count({<flag={1}>}Model)

For Second table company report : =Count({<flag={2}>}Model)

soniasweety
Contributor III

Re: concatenate

thanks all ,I will check and update you

soniasweety
Contributor III

Re: concatenate

if I have the column names are different but inside values are same   how can I get join and use?

example:   1st table column name :company 

2nd table  columnname :business       I need to combine count I want to show  how to map this?

Community Browser