how to create a group by on qvd file?

[Anonymous]

i want to create a griup by on qvd on a qvd file table ..

and output also please show me some example on that

[arasantorule]

Hi,

Can you please explain your requirement in detail.

Thanks.

[#3]

Do it in loading script is a workable solution FYR: GROUP BY requires ALL fields? Alternatively, You can also create a new field with "if", then using this field to call the group in order to display. Hope these helps!

[Anonymous]

i want syntax and example and output for group by

on qvd file

[Anonymous]

Hi Please see the attached .

In order to group by to work you have to do some aggregations to all the fields in the Table except one field which you gonna use in your group by statement .

[arasantorule]

Hi Bhnanu,

There are plenty of examples in our community

One of them is below answered by Miguel.

Using aggregation funuctions in Script | Qlik Community‌

Thanks.

[Anonymous]

sory bro i let u no my doubt more clearly

T:

LOAD GRADE,

    sum( LOSAL) as lowsal,

     HISAL

FROM

(qvd)

group by GRADE,HISAL;

tell me this syntax is correct r not and i want to do sum of sal that means i shud get all salary sum..final

[Anonymous]

yes the Syntax is correct . Can you share your data .

[Anonymous]

T:

LOAD GRADE,

            LOSAL,

            HISAL

FROM

(qvd)

THIS IS MY t table having salgrade table