Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I have a list box with 3 values ORDER, SHIPMENT and INVOICE and 3 variables vOrder, vShipment and vInvoice

I have a list box with 3 values ORDER, SHIPMENT and INVOICE  and 3 variables vOrder, vShipment and vInvoice

Scenario1: When  I select ORDER from list box the vOrder should set to 1 and vShipment and vInvoice set to 0

Scenario 2: When  I select SHIPMENT from list box the vShipment should set to 1 and vOrder and vInvoice set to 0

Scenario 3: When  I select INVOICE  from list box the vInvoice should set to 1 and vOrder and vOrder set to 0.

With Regards,

Aaryan

3 Replies
avinashelite

try like this in the variable

eg:

varaibale :vOrder

expresssion: if(getfieldselections(fieldname)='ORDER' and getselectedcount(fieldname)=1,1,0)

tresesco
MVP
MVP

vOrder=If(Field='ORDER',1,0)

vShipment=If(Field='SHIPMENT,1,0)

vInvoice=If(Field='INVOICE',1,0)

sunny_talwar

or this:

Capture.PNG

Capture.PNG