Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grouping of columns.

I have my columns as below

Load

A,

B,

C,

D,

E,

F,

G

From Source ;

I want to group CDE in one bucket called milestones as well as want to keep them as separate fields also.Can I do that ?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Perhaps like this:

Table1:

LOAD * FROM TEXT.xlsx (ooxml, embedded labels, table is Sheet1);

Table2:

CrossTable(Milestone, Date,2)

LOAD A, B, C, D, E

FROM TEXT.xlsx (ooxml, embedded labels, table is Sheet1);


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

I want to group CDE in one bucket called milestones as well as want to keep them as separate fields also

What do you mean? Can you post an example of the resulting table you expect?


talk is cheap, supply exceeds demand
Not applicable
Author

PFA...I want to group column C,D and E as Milestone Dates and also want to keep them as individual date columns.

Thanks much gwassenaar

Gysbert_Wassenaar

Perhaps like this:

Table1:

LOAD * FROM TEXT.xlsx (ooxml, embedded labels, table is Sheet1);

Table2:

CrossTable(Milestone, Date,2)

LOAD A, B, C, D, E

FROM TEXT.xlsx (ooxml, embedded labels, table is Sheet1);


talk is cheap, supply exceeds demand

View solution in original post

pk2019
Partner
Partner

Hi Pavana,

Is this what you were looking for, to combine the fields?

[Sheet1]:

LOAD

    ,

    ,

    ,

    ,

    ,

    & '|' & & '|' & as "Milestone Date",

    ,

   

FROM [lib://Desktop/TEST.xlsx]

(ooxml, embedded labels, table is Sheet1);

The result is something like this: