topic Re: Re: Mix columns issue in QlikView

Mix columns issue

Fri, 22 Aug 2014 05:37:43 GMT

Hi All,

I have one table which contains Stage2,App Name, Phase, Dev Plan Finish, Dev Actual Finish, Test Plan Finish,

Test Actual Finish,Production Plan Finish, Production Actual Finish columns.

Now i have to display this data in Straight or pivot table, here i need to mix Dev Plan Finish, Dev Actual Finish, Test Plan Finish,

Test Actual Finish,Production Plan Finish, Production Actual Finish columns into 2 columns Planned and Actual. All planned values should come

in Planned field and Actual values should come in Actual values.

For example If phase = production then i need to pick Production Planned and Actual dates but don't pick Dev Plan And Actual Finish dates

as well as If phase = Dev then i need to pick Deb Planned and Actual dates but don't pick Production Plan And Actual Finish dates

and if Stage = Production but there are no dates in production then it should take Dev dates in Planned and Actual

If both DEV and PRODUCTION don't have dates then it should not consider that record.

i attached sample data file and qvw and REQ screenshot also, could you please anybody respond on this.

Thanks,

Chiru

Re: Mix columns issue

Fri, 22 Aug 2014 09:06:56 GMT

Hi Guys any ideas?????????????

Re: Mix columns issue

Fri, 22 Aug 2014 09:11:06 GMT

Hi Chiranjeevi,

Please check this out.

Thanks,

Sri

Re: Mix columns issue

Fri, 22 Aug 2014 10:57:51 GMT

Hi Srikar,

Thanks for your reply.

some how your suggestion is working but for the 3rd record in excel Phase = PROD but there are no dates for PROD then it should pick DEV dates.

is there any solution for this?

Thanks in advance,

Vamsi

Re: Re: Mix columns issue

Fri, 22 Aug 2014 11:55:44 GMT

Attached the modified file, plz check it out.

1st eliminated the rows from the source using the where condition where the Dev & Prod Plan/Actuals are null.

2nd the conditions whichever you specified., like if Phase is DEV then DEV PLAN/ACTUALs should display, if Phase is PROD then PROD PLAN/ACTUALs should display, if Phase is PROD and PROD PLAN/ACTUALs is NULL then display DEV PLAN/ACTUALs

Thanks,

Sri

Re: Mix columns issue

Mon, 25 Aug 2014 07:45:22 GMT

Hi Chiranjeevi,

Did the solution work?

Thanks,

Sri

Re: Mix columns issue

Wed, 03 Sep 2014 06:10:57 GMT

Hi Srikar,

Sorry for late reply, that's working perfect. Thanks for your effort

Thanks,

Chiru