Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Groupping of Columns and create sub group

Dear all,

I have following  data   i want to create groups like name,address,salary in load  script how I can do this ?

 

GROUPSNAMEADDRESSSALARY
FIELDSNAMECITY STATECOUNTRYREGIONBASICDA

HRA

Thanks

Vikas

4 Replies
Anonymous
Not applicable

use the Group by function

Table1:

load

Field1,

Field2,

sum(Value1),

sum(Value2)

from ...

Group by Field1, Field2

You Need to define every field in the Group by clause and you Need to use a functtion like sum, max etc. for each value

bunnyv123
Creator II
Creator II

Hi,

Here is the example :-

LOAD * INLINE [

    BOOKID, TITLE, AUTHOR, PAGES, COUNTRY, QUANTITY

    B001, Harry Poteh! Book 1, JK, 800, UK, 18

    B002, Harry Poteh! Book 2, JK, 900, UK, 49

    B003, Harry Poteh! Book 3, JK, 902, UK, 26

    B004, Harry Poteh! Book 4, JK, 899, UK, 15

    B005, Harry Poteh! Book 5, JK, 901, UK, 11

    B006, Harry Poteh! Book 6, JK, 800, UK, 25

    B007, Harry Poteh! Book 7, JK, 789, UK, 31

    B008, Harry Poteh! Book 8, JK, 678, UK, 50

    B009, Harry Poteh! Book 9, JK, 876, UK, 35

    B010, Harry Poteh! Book 0, JK, 901, UK, 22

    B011, Harry Hudin! Book 1, MA, 844, SG, 49

    B012, Harry Hudin! Book 2, MA, 801, SG, 32

    B013, Harry Hudin! Book 3, MA, 902, SG, 48

    B014, Harry Hudin! Book 4, MA, 816, SG, 31

    B015, Harry Hudin! Book 5, MA, 918, SG, 49

    B016, Harry Hudin! Book 6, MA, 909, SG, 21

    B017, Harry Hudin! Book 7, MA, 821, SG, 24

    B018, Harry Hudin! Book 8, MA, 831, SG, 21

    B019, Harry Hudin! Book 9, MA, 958, SG, 25

    B020, Harry Hudin! Book 0, MA, 838, SG, 42

];

load * INLINE [

  DIMENSION

  BOOKID

  TITLE

  AUTHOR

  PAGES

  COUNTRY

];

Hope this helps.

Thanks,

Bunny

vikasmahajan
Author

NOT CLEAR PLEASE CAN YOU GIVE EXAMPLE ?

bunnyv123
Creator II
Creator II

Hi,

Check the attached app .

i think this helps.

Thanks , !

Bunny