topic Or statement in Concat in QlikView

Or statement in Concat

varunreddy — Thu, 29 Oct 2015 17:40:24 GMT

Hi Guys,

I am using a button with layout condition

Concat(Driver) = 'BCBSBCBS-AccuracyBCBS_Completeness) - This button works only if I select all together.

My requirement is Button needs to work if I select BCBS or BCBS_Timeliness or BCBS_Completeness

Is there a way to do?

Regards,

Varun

tamilarasu — Thu, 29 Oct 2015 18:08:43 GMT

Hi,

Try like below,

Match(Driver,'BCBS','BCBS_Timeliness', 'BCBS_Completeness')

Or simply

Wildmatch(Driver,'BCBS*')

Let me know..

varunreddy — Thu, 29 Oct 2015 18:17:22 GMT

Hi Nagaraj,

I am using an action - Clear field - Driver

Layout condition - Concat(Driver) = 'BCBSBCBS-AccuracyBCBS_Completeness).

When I select a butoon. It will disappear.

Thanks for your response, but they are not working.

Cheers!

tamilarasu — Thu, 29 Oct 2015 18:24:20 GMT

I dont understand your question.. could you bit more specific? What does the button do? Where you assigned the layout condition?

Thu, 29 Oct 2015 18:31:56 GMT

Varun,

Can you give a try by adding field event trigger to show button on those 3 in document properties.

Thanks

Brad.

varunreddy — Thu, 29 Oct 2015 18:33:37 GMT

My requirement is, If i select a button ,it should show field values and if I select same button, it should clear the selections.

So, I used two buttons. If I select the button with values, the button with clear field will be shown and first button will be hidden.