how to get output using multiples fact tables - Qlik Community

vikasmahajan · ‎2011-08-21

Attaching here all tables output required like following

sales group - spade

Month - June

hq name abm name dbm name

Mesana

------------------------------------ Current Month ----------------------- ------------------------------------------- ytd ------------------------------------------------

product name annual tar (tar_qty) targets(12000*monper.per) tys(net units from tys) targets(ytd) ach(ytd) lys(ytd

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

abc -------- 12000 1080 504 April to june)2640 1577 1008

Please help me to get this output

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2011-08-21

Hi vikasmahajan,

from which fact tables? this is quite confusing for me. Can you please show the fact tables and then gives a clear idee of the tables output that you want get (with columns names, etc...).

Regards.

Report Inappropriate Content · ‎2011-08-21

Ok, please do so on the advanced Edit option.

vikasmahajan · ‎2011-08-22

Dear Sir,

I have attached my all excels sheets in that i want to display output

MONTH - JUNE

HQ NAME RM NAME DM NAME

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

<---------- Current Month --------------- ------------------->

PRODUCT ANNUAL TAR Target (month ie june) Ach Qty Lys Ach Qty (BELOW YTD)

(Target Qty from target.xls) ( tar_qty*monper.per/100) (net_qty from (net Qty

tys for june) from Lys.xls for june10)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Same columns required in ytd in c

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

<---------- Current Month --------------- ------------------->

PRODUCT ANNUAL TAR Target (month ie june) Ach Qty Lys Ach Qty

(Target Qty from target.xls) ( tar_qty*monper.per/100) (net_qty from (net Qty

tys for june) from Lys.xls for june10)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2011-08-22

There is nothing here vikasmahajan. Here is what you should do on QlikCommunity:

look at any of the posts you've sent (preferably the latest above), Click on Edit. On the next page that appears, at the bottom, there is an option that allows you to 'Chose the file' you need to upload. Then Clik on 'Update' when you've finished chosen the file.

Regards.

Report Inappropriate Content · ‎2011-08-22

Ok thanx, I got it. Will get back to you as soon as possible.

Regards.

vikasmahajan · ‎2011-08-23

Thanks in advanace sir , and shown interest to resolve issue

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.