Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add the product and Month/Year to your dimensions
Then on the report itseld, drag and drop them above your expressions
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
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.
Hi,
can any one have idea about this..
reards.
baru
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