Is it possible in QlikView....

[#1]

Hi,

I got a new requirement from my client.I want to develop a 4 report that is in tabular format like....

Dimension

Product 1

Product 2

Oct'12

YTD Oct'12

Growth % Over

Oct'12

YTD Oct'12

Growth % Over

Sales

Target

% Target

Sales

Target

% Target

Oct'11

Dec'11

Current Month

YTD

Sales

Target

% Target

Sales

Target

% Target

Oct'11

Dec'11

Current month

YTD

I never develop and didn't seen like this report in qlikview.In this report product is a dimension,that we can drag from rows to columns this we can do it and measures in green colour also we can do it,but my question is how to display Oct'12,YTD Oct'12 and Growth % Over(which is in red colours) in the table.Is there any way to display these format in qlikview.

I know we can represent text objects in the top of the table.

But my client is taking this report from access point and converting it into excel with one click.

Can any body know the solution for this..

Thanks in advance,

regards,

baru

[#2]

Add the product and Month/Year to your dimensions

Then on the report itseld, drag and drop them above your expressions

[#3]

Hi Brianm,

thanks for your reply,

can i have any sample example about this format and product and month/year together in dimension.

regards,

baru

[jagan]

Hi,

I think you need to use ValueList() in dimension.  Hope attached file helps you.  You need to generate the ValueList() values dynamically based on the date.  In attached it is hard coded values in ValueList().

Regards,

Jagan.

[#5]

Hi,

can any one have idea about this..

reards.

baru

[#6]

Hi Community,

Can anybody help in this issue or

is it possible to write in macro to resolve this issue,getting column name(which is in red colour).

thanks in advance,

regards,

baru