topic How to apply a flag into all connected tables in QlikView

How to apply a flag into all connected tables

Mon, 01 Sep 2014 05:15:57 GMT

Hi all,

I have number of tables namely contract table, budget table, Dispatch table, Invoice table, Expense voucher tables. In that CONTRACTNO is link field.

Link field contractno will appear in all above noted tables. Each table has child tables. all tables are concatenated based on the requirement.

My question is need to separate the Finished contract & Unfinished Contract. Finished Contract which means, a contract should completed all data entry process on above noted tables. I do update Contract tables as Finished flag when contract is complete, this flag should not effect in remaining tables.

I need the Finished flag should effect in all tables.... How should i connect tables for this

Regards

Vignesh Babu.CV

Re: How to apply a flag into all connected tables

ashwanin — Mon, 01 Sep 2014 05:19:00 GMT

Hi Vignesh,

Please attach some sample data.

Re: How to apply a flag into all connected tables

deepakqlikview_123 — Mon, 01 Sep 2014 05:23:32 GMT

Hi Vignesh,

You cbelow condition to set flag,

If(Fieldname= 'Finished contract',1,0) as Flag,

In this way you will set flag 1 for Finished prod and 0 for unfinished prod.

I do not know where u have concatenated your tables.But you have to use this condition for each one where u need to set a flags.

Thanks,

Deepak

Thanks,

Deepak