How Do i Transform date as Column and fill with amount....

[#1]

GooDay Dear All,

i am very new to QlickView i have learned a lot from your blogs,But need your help please..

I have requirement for the blow data how can i transpose the below data to QV report as my client asking for.

i am bit confused of how i can achieve this..

SalesID  Customer ID CustomerAccnumber  Amount/Sales  OrderDate

11111     C55555        6778888                      5768              2/12/2014

To in QV Report:

SalesID  Customer ID CustomerAccnumber  2/12/2014    1/12/2014  ....................

                                                                 (  Amount)    (Amount)

11111     C55555        6778888                      5768              5222

They want the above format that they can check for Past  1 week from today, and as well as for 90 days past from today, the report should expand on the right hand side with the date on the column head and filled with Amount for that date.it should change dynamically.

This scenario but i don't know how i can achieve, where can i achieve this(Means in Scrip logic while loading data or in the Layout), they don't want any dashboard like i showed them some dashboards as well , they want it like excel style like QV table or straight table.

Please let me know how we do this.

Thanks for your help.

Thanks

NS

[#2]

Dear Nagesh

Please see file attached for solution

Regards

Rahul

[#3]

Dear Rahul,

Thanks for the quick response,

But i  want the date has to be dynamically appearing on the column as when we choose the time frame and should expand dynamically based time frame we choose,

Sorry if was not clear in my post.

Thanks

Nagesh

[m_woolf]

Would the customer be happy with a QV pivot table?

[#5]

something like the attached?

Regards

RL

[#6]

Hi M W,

That looks similar and i will show them, please let me know how do i do that, will help me a lot, and i come back to you.

It does not matter how we do it, but they want this should be used as excel output later for them.can we do that?

Thank you very much.

Thanks

Nagesh

[m_woolf]

See attached qvw:

[#8]

Hi M W,

I am getting 'out of object memory error',

and please let me know how do i set to time frame for the past 1 week and 90 days buttons or textbox.

Thanks

Nagesh

[MarcoWedel · Accepted solution]

Hi,

Michael Woolfsolution works for me.

For the selection question I added two search buttons:

hope this helps

regards

Marco