Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
Cross table in single table two times
hi jagan u can find the same data here..
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.