topic Re: Cross Table in QlikView

Cross Table

Mon, 31 Dec 2012 06:13:38 GMT

Dear Members,

I have a Sample Data

I need to convert That data into Given Format

I am Attaching sample Excel

pls find and give me proper Advice

Sheet1: Base Data is Sample Data

Sheet2: Format

I want All Aging like 0-31 and 31-60 ..............

will be in single dimension like

Ageing,amount

0-31,10000

31-60,30000

like this i want

Re: Cross Table

khadeer — Mon, 31 Dec 2012 06:28:30 GMT

Hi RAM PFA

Re: Cross Table

Mon, 31 Dec 2012 06:46:43 GMT

Hai khadeer,

Thanks for Replying This is Same Wt I have done here but they are ASKING

Two Formats like Wt in second sheet pls see the second sheet

Re: Cross Table

Mon, 31 Dec 2012 06:50:57 GMT

Hi RAM G,

I think you can concatenate two Columns with the help of "&" operator.Go to Properties & in Expression,write your expression. expression1 & expression2 For eg. :- Ageing & Amount

Thanks