Cross table

[#1]

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 · Accepted solution]

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

[Gabriel]

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]

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.