topic Re: REG-CONDITION in QlikView

REG-CONDITION

Tue, 12 May 2015 04:43:25 GMT

Hi Team,

i have one question we have different filters like BU ,BRAND,YEAR.,

WE HAVE FILED LIKE CI,EH,SA IN BU LISTBOX AND BRAND= ESSENTAILE AND SO ON IN THE BRAND LIST BOX AND YEAR=201501,201502,201503.

if the user select BU=CI AND BRAND =ESSENTIAE AN DYEAR=201501,201502,03 THE BU=CI SHOULD BE CHANGE FROM CI TO EH

CAN ANY ONE HELPME IN WRITING THIS EXPRESSION.

This is very urgent can anyone helpme out

Re: REG-CONDITION

Tue, 12 May 2015 04:57:00 GMT

As I understand this as you need to override the selection on the BU listbox, when given combo(BU=CI, BRAND = ESSENTIAE and DYEAR=201501,201502, 201503) is selected?

You can take use of Select in Field trigger to override the selection.

Re: REG-CONDITION

Tue, 12 May 2015 04:59:15 GMT

Yes if the user selects the BU=CI AND BRAND=ESSENTIALE AND YEAR>=2015 THE BU Should be changed from CI TO EH.Can you please help me in this

Re: REG-CONDITION

Tue, 12 May 2015 05:04:23 GMT

Hi,Angad

Can you please help me in writing this condition to override this and hel p me out from this

THNXS

Re: REG-CONDITION

Tue, 12 May 2015 05:05:34 GMT

Go to Field event triggers under documnent properties, choose select in field and give your criteria. Hope it helps you or post your app here, I will do that for you.

Re: REG-CONDITION

Tue, 12 May 2015 05:16:33 GMT

@Hi naveen please find the below image and i want like this in my report

Re: REG-CONDITION

Tue, 12 May 2015 05:24:01 GMT

HI Naveen can you please help me in this

Re: REG-CONDITION

Tue, 12 May 2015 05:27:40 GMT

Hello Rao,

Please follow below steps to achieve this.

>> Go to Document Settings-> Triggers-> Field Event Triggers

>> Create onSelect Trigger for :

>> BU

>> BRAND

>> DYear

>> Choose 'Select in Field' trigger and Write BU as the Field and in Search String write:

=if(GetFieldSelections(BU)&'|'& GetFieldSelections(BRAND)&'|'& GetFieldSelections(DYear) = 'CI|ESSENTIAE|201501,201502, 201503','EH',BU)

Hope this is helpful or correct

Thanks,

Singh

Re: REG-CONDITION

Tue, 12 May 2015 05:46:02 GMT

THNX and can i write this exp in my list box for BU ALSO

Re: REG-CONDITION

Tue, 12 May 2015 05:46:23 GMT

!Hi,

You can try the attached solution, but here selection sequence matters.

Re: REG-CONDITION

Tue, 12 May 2015 07:29:52 GMT

Hi Angad

i have tried but it is not working

Re: REG-CONDITION

Tue, 12 May 2015 07:42:34 GMT

Check in attached app, you will get idea.

Re: REG-CONDITION

Tue, 12 May 2015 07:44:51 GMT

I have implemented in the similar way,

Please have a look at the attachment.

Hope this is helpful.

Thanks,

Singh

Re: REG-CONDITION

Tue, 12 May 2015 07:58:39 GMT

its working but the BU =CI SHOULD BE CHANGED TO EH not coming

Re: REG-CONDITION

Tue, 12 May 2015 08:06:53 GMT

If you take up the same approach and same steps, then I guess you will be able to achieve what is required.

Hope this is helpful.

Thanks,

Singh