topic Re: Scenario Help in QlikView

Scenario Help

abhaysingh — Fri, 29 Jan 2016 01:50:55 GMT

Hi GUys,

I have budget data in cross table format on the basis of month, in which i have year a field and and budget qty in raw form,

i dont have the DATE in budget table

even i don't have the primary key.

Now i m required to make the dates in my budget data, so i tried to join my calendar on the basis of year and month (Composite key),

but when i am doing so my data is multiplying bcoz of not unique in nature.

and i have second table SalesPlan in which year and weeks are available Not Unique, the same process when i m trying to do in Sales plan table to feed the dates in my data my data are multipying and giving wrong result to me..

at last i need to put the data in single raw Budget and Sales Plan to make it work over the common stuff.

Any suggestion ?

Re: Scenario Help

jagan — Fri, 29 Jan 2016 01:56:24 GMT

HI,

Attach some sample data in Excel file then it would be easier to understand the data and can provide the solution without that it is very difficult to understand.

Qlik Community Tip: Posting Successful Discussion Threads

I think if you have Month/Week and Year then we can easily form the Date.

Regards,

Jagan.

Re: Scenario Help

abhaysingh — Fri, 29 Jan 2016 01:58:45 GMT

Cross table in single table two times

hi jagan u can find the same data here..

Re: Scenario Help

jagan — Fri, 29 Jan 2016 02:21:22 GMT

Hi,

Is that script not working in that thread? Where is sales plan and budget data in that? You should be specific, about your requirement and what is your expected output then only it is easier to provide solution.

Regards,

jagan.