Link Table Problem

[pkpandey]

Hi All

I need help in making a link table. I have two tables with different dates like MOVE_TIME,ARRIVAL_TIME and PERIOD_START and based on these dates I have to generate reports. But how will I make a link table to do that. Please advise Tables are attached. This is urgent.

Thanks in advance.

[pkpandey]

Its a hierarchical type of data. On selection of Lot Type all product group will be displayed under that lot type. on selection of Product Group all the products will be displayed under that product group and so on.

[kaushiknsolanki]

Hi,

In  the equipment charts, remove the " EquipmentGroupId= "from the expressions.

Regards,

Kaushik Solanki

[pkpandey]

In the equipment charts there is not equipmentgroupid.

On Tue, 08 Mar 2016 14:35:06 +0530 Kaushik Solanki wrote

Link Table Problem

reply from Kaushik Solanki in QlikView Deployment - View the full discussion

Hi,In the equipment charts, remove the " EquipmentGroupId= "from the expressions.Regards,Kaushik

Solanki

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in QlikView Deployment by email or at Qlik Community

Following Link Table Problem in these streams:

Inbox

© 1993-2016 QlikTech International AB |

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

[kaushiknsolanki]

Hi,

sum({<TranDate={'>=$(vPeriodFrom)<=$(vPeriodTo)'}, EquipmentGroupId=>} T2.LOT_SIZE_MOVE)

Above is the expression which I see in your equipment charts.

I am asking you to remove , EquipmentGroupId= So your expression should be

sum({<TranDate={'>=$(vPeriodFrom)<=$(vPeriodTo)'}>} T2.LOT_SIZE_MOVE)

Regards,

Kaushik Solanki

[pkpandey]

Yes this expression is for equipment group, and I have done that but there is no effect.

On Tue, 08 Mar 2016 14:49:07 +0530 Kaushik Solanki wrote

Link Table Problem

reply from Kaushik Solanki in QlikView Deployment - View the full discussion

Hi,sum({} T2.LOT_SIZE_MOVE)Above is the

expression which I see in your equipment charts.I am asking you to remove , EquipmentGroupId= So your

expression should besum({} T2.LOT_SIZE_MOVE)

>Regards,Kaushik Solanki

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in QlikView Deployment by email or at Qlik Community

Following Link Table Problem in these streams:

Inbox

© 1993-2016 QlikTech International AB |

Copyright & Trademarks | Privacy | Terms of Use | Software EULA