topic Expression help in QlikView

Expression help

satishkurra — Wed, 02 Mar 2016 17:36:32 GMT

Hi All

I have the expression below where it should display the below column values (answer_....) when we select Other on the UI and for other than OTHER, it should show the selections made

For example Behavioral Health has other values as Not Required and Required, if we select Required or Not Required, it should display that value

For example Services has other values as Not Required and Required, if we select Required or Not Required, it should display that value

if([Behavioral Health] = 'Other', answer_text_short_bhh,

if(Services = 'Other', answer_text_short_spp,

GetCurrentSelections()))

Can someone help me on the same?

Thanks

Satish

Re: Expression help

sunny_talwar — Wed, 02 Mar 2016 17:40:03 GMT

Would the selection be made in only one of them or can be made in both? I am getting confused of how the user will interact with the application. Can you elaborate?

Re: Expression help

satishkurra — Wed, 02 Mar 2016 17:45:26 GMT

if the user selects Other, it should display the values from Others, if they select Required or Not Required it should display accordingly.

In the similar way i have other columns where it has Other, Required and Not Required Columns

At the end the user will select only 1 value at a time.

Hope it is clear

Re: Expression help

sunny_talwar — Wed, 02 Mar 2016 17:47:23 GMT

May be this:

If(FieldName = 'Other', 'SomethingYouWantUserToSee', FieldName)

Re: Expression help

satishkurra — Wed, 02 Mar 2016 17:49:38 GMT

But the problem is i cannot close the if condition because i have other field names as well.

Infact i tried before the option you provided.

Re: Expression help

sunny_talwar — Wed, 02 Mar 2016 17:52:23 GMT

So lets take a scenario. If have two fields

Field1

Other

Required

Not Required

Field2

Other

Required

Not Required

If in either of them the user selects Other you would want to show text otherwise both of their content?

Re: Expression help

satishkurra — Wed, 02 Mar 2016 18:05:00 GMT

Hi Sunny

Let me put here in an example. Apology for the confusion

LOAD * Inline [

Facility

Required

Not Required

Other ];

LOAD * Inline [

Services

Required

Not Required

Other ];

if user selects Other in Services, it should display values for Other for Services,

if user selects Other in Facilities, it should display values for Other for Facilities,

if user selects Required in Services, it should display values for Required for Services,

if user selects Required in Facilities, it should display values for Required for Facilities,

if user selects NOT Required in Services, it should display values for Required for Services,

if user selects NOT Required in Facilities, it should display values for Required for Facilities,

All the above condition should be achieved in 1 single expression.

Request to please let me know if it is not clear.

Thanks

Satish

Re: Expression help

satishkurra — Wed, 02 Mar 2016 18:08:13 GMT

Sunny we can write 3 conditional expressions for facilities and other 3 for services, but the data contains 5 tables like facilities and services with not only Other, Required and NOT Required, we have many other field values...

Re: Expression help

sunny_talwar — Wed, 02 Mar 2016 18:08:54 GMT

One last question. When you say values are you referring to the three values we see for services here?

Satish Kurra wrote:

if user selects Other in Services, it should display values for Other for Services

or is it another field's values?

Re: Expression help

satishkurra — Wed, 02 Mar 2016 18:15:42 GMT

Yes Sunny

Re: Expression help

sunny_talwar — Wed, 02 Mar 2016 18:24:28 GMT

This me just guessing, what if you do:

Service&Facility

When user doesn't have anything selected -> Output is null

When user selects 'Others' in Services -> Output is Others

When user selects 'Others' in Facility -> Output is Others

and so on...

Re: Expression help

sunny_talwar — Wed, 02 Mar 2016 18:26:50 GMT

Check if the attached is what you want