Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dnowebdn
Contributor
Contributor

combine

I have to combine all into one chart

1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

You can do it with a new table as below:

tab_a:

load

     Category

     Category as New_Category

Resident now;

concatenate

load

     Category,

     'all' as New_Category

Resident now;


In the UI you can use New_Category field as filter/dimension.


I hope it helps.

View solution in original post

3 Replies
sunny_talwar

May be this

Table:

LOAD Sales,

    Month,

    Year,

    Category,

    KPI,

    Country,

    brace

FROM

[..\..\Downloads\Tests.xlsx]

(ooxml, embedded labels, table is Sheet1);


Concatenate (Table)

LOAD Sales,

    Month,

    Year,

    'All' as Category,

    KPI,

    Country,

    brace

Resident Table;

or this

Table:

LOAD Sales,

    Month,

    Year,

    Category,

    KPI,

    Country,

    brace

FROM

[..\..\Downloads\Tests.xlsx]

(ooxml, embedded labels, table is Sheet1);


Concatenate (Table)

LOAD DISTINCT Sales,

    Month,

    Year,

    'All' as Category,

    KPI,

    Country,

    brace

Resident Table;

Anonymous
Not applicable

If you were to create this additional category then there would be no data for it, why do you want to create a third category instead of just selecting two categories simultaneously?

agigliotti
Partner - Champion
Partner - Champion

You can do it with a new table as below:

tab_a:

load

     Category

     Category as New_Category

Resident now;

concatenate

load

     Category,

     'all' as New_Category

Resident now;


In the UI you can use New_Category field as filter/dimension.


I hope it helps.