topic Cross table in QlikView

Cross table

Mon, 15 Jul 2013 14:38:58 GMT

Hi All,

What is crosstable in Qlikview ?

I have yearly budget data coming by month. I need to have a filed which combines all the month names and gives me in a single field .

Please find attchment

Apprecite help on this

Gysbert_Wassenaar — Mon, 15 Jul 2013 14:48:23 GMT

See attached qvw. If that is not what you need then you'll have to explain in more detail what you want.

Gabriel — Mon, 15 Jul 2013 14:54:46 GMT

Hi,

Just so am clear in my mind what you need help with. What you want is the new file or latest file to be append to the old file all happening in QV?

So say,

You have January data file and now Feb data file has arrived and you want thses 2 file in 1 file? Is this what you want?

Best Regards,

Gabriel

jagan — Wed, 17 Jul 2013 15:42:29 GMT

Hi Srinu,

Try this row to remove total row at the bottom.

Data:

CrossTable(RevYear, Amount, 3)

LOAD ClientName,

Year,

AnualTotal,

JAN,

FEB,

MAR,

APR,

MAY,

JUN,

JUL,

AUG,

SEP,

OCT,

NOV,

DEC

FROM

YearlyBudget.xlsx

(ooxml, embedded labels, table is 2013)

WHERE Trim(Len(ClientName)) > 0;

Hope this helps you.

Regards,

Jagan.