Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
koushik_btech20
Creator
Creator

Making a Flag over one field on basis of another field

I am facing a problem on creating a flag(Shipping Status). In my data model, on main fact table we can get the product inovoice(InvoiceNo) wise sale. Now on another table(Shippment) we can find the CommercialInvoiceNo linked with main fact table by OrderId and InvoiceNo(Composite key). Now for some InvoiceNo, Commercial Invoice No is null. So I have to create a flag on the basis of InvoiceNo, i.e. If CommercialInvoiceNo is null on the basis of InvoiceNo then product is not shipped else shipped.By these logic ship status flag will be created. So anyone have any solution then share.

4 Replies
MK_QSL
MVP
MVP

What is the common field in both table? ShipKey?

Unclear from you explanation as your explained fields are not matching with your example field.

alexandros17
Partner
Partner

Here it is

koushik_btech20
Creator
Creator
Author

Sorry friends I have provided the wrong example qvw application. Providing the actual qvw example file where in Shipment table there are no balnk commercial invoice no. Now we have to create the flag(shipstatus). ShipKey is the common field.

alexandros17
Partner
Partner

Take a look to the document ...

Hope it helps