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

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

Thu, 07 Aug 2014 11:05:52 GMT

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

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

Thu, 07 Aug 2014 11:41:43 GMT

Dear Nagesh

Please see file attached for solution

Regards

Rahul

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

Thu, 07 Aug 2014 12:18:52 GMT

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

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

m_woolf — Thu, 07 Aug 2014 12:20:40 GMT

Would the customer be happy with a QV pivot table?

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

Thu, 07 Aug 2014 12:26:30 GMT

something like the attached?

Regards

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

Thu, 07 Aug 2014 12:33:07 GMT

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

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

m_woolf — Thu, 07 Aug 2014 12:42:43 GMT

See attached qvw:

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

Thu, 07 Aug 2014 13:41:01 GMT

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

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

MarcoWedel — Fri, 15 Aug 2014 23:29:45 GMT

Hi,

Michael Woolfsolution works for me.

For the selection question I added two search buttons:

hope this helps

regards

Marco