topic Re: Need Help in QlikView

Need Help

Fri, 21 Feb 2014 15:57:28 GMT

Hi Community,

See below image,

I have 1 execution date and OrderAge field...

when i am reload tomorrow i want add date and OrderAge

Key CoverageStatus Execution_Date Order_Age

asd True 2/12/2014 1

pasd False 2/12/2014 6

when i am reload tomorrow i want add 2 columns and Order_Age Increasing with +1

like this

Key CoverageStatus Execution_Date Order_Age Execution_Date Order_Age

asd True 2/12/2014 1 2/13/2014 2

pasd False 2/12/2014 6 2/13/2014 7

Thanks in Advance......................

Re: Need Help

Gysbert_Wassenaar — Fri, 21 Feb 2014 16:07:07 GMT

And the day after tomorrow? Do you then need 4 more columns compared to today?

Re: Need Help

datanibbler — Fri, 21 Feb 2014 16:10:18 GMT

Oh my,

that is indeed somewhat complicated:

- I'd do it in a LOOP (rather say, I'd try...)

- Count from day x (0,1,2,3 ...)

- Depending on that value, join fields with (reloaddate()-x)

- For the Order_Age, you have a starting_value and you just add your loop_value to it, that way it will increase by 1 every day.

HTH

Best regards,

DataNibbler

Re: Need Help

aveeeeeee7en — Fri, 21 Feb 2014 16:14:03 GMT

Hi Sunil

See the Attached.

Re: Need Help

Fri, 21 Feb 2014 16:15:02 GMT

Hi Gysbert,

Like this

When i am reload everyday i want to add 2 columns, like this

Key CoverageStatus Execution_Date Order_Age Execution_Date Order_Age Execution_Date OrdAge

asd True 2/12/2014 1 2/13/2014 2 2/14/2014 3

pasd False 2/12/2014 6 2/13/2014 7 2/14/2014 8

Re: Need Help

aveeeeeee7en — Fri, 21 Feb 2014 16:16:04 GMT

If you have to do this everyday than you can use Today() Date in Variable and in expression add +1 to both Date and Age.

Re: Need Help

Gysbert_Wassenaar — Fri, 21 Feb 2014 16:22:02 GMT

Don't create extra columns, but load each days records in the same columns. Then use a pivot table to show the Execution_Date values horizontally instead of as a column. You can use an expression to show the Order_Age for the date value.

Re: Need Help

Fri, 21 Feb 2014 16:26:09 GMT

Hi, I am using pivot table but i am not getting properly.........

Re: Re: Need Help

Fri, 21 Feb 2014 16:40:30 GMT

Hi ALL,

PFA,

Re: Re: Need Help

Fri, 21 Feb 2014 16:41:44 GMT

Hi Gysbert,

How to write expression Here?

Re: Re: Need Help

Gysbert_Wassenaar — Fri, 21 Feb 2014 16:44:40 GMT

Since you have only one Order_Age per date you can use max(Order_Age) or min(Order_Age) or avg(Order_Age) or sum(Order_Age) or only(Order_Age). Any of these will do. See attached qvw.

Re: Re: Re: Need Help

aveeeeeee7en — Fri, 21 Feb 2014 16:59:52 GMT

Check this.