topic Re: Trigger Help in QlikView

Trigger Help

ajaykumar1 — Mon, 08 Jun 2015 14:23:43 GMT

Hi Everyone,

If i enter into the sheet by default certain should be select mode always.For that i have done like below

Sheet Properties---Triggers---select in field---

I have the field country and the values are below.

Austria

Benelux

Denmark

Dubai

Finland

France

Germany

Great Britain

Hungary

Italy

Norway

Pan-Europe (CP)

Poland

Portugal

Slovakia

South Africa

Spain

Sweden

Switzerland

I tried like below :

But its not working.I need to resolve this then i need to go ahead with further requirement.

More Thanks in advance,

Ajay

Re: Trigger Help

awhitfield — Mon, 08 Jun 2015 14:40:58 GMT

Hi ajay

you don't need the quotes, just (Austria|Benelux|Denmark) , gives:

HTH

Andy

Re: Trigger Help

maxgro — Mon, 08 Jun 2015 14:51:38 GMT

if you have some space

("Austria"|"Italy"|"Great Britain")

Re: Trigger Help

santhoo_san — Mon, 08 Jun 2015 15:01:02 GMT

You create a mapping field for these countries and take that Mapping field in your trigger

Sheet Properties ---> Triggers----- > select in field --- > Field = GrpCountry , search string = 'Group'

Country	GrpCountry
Austria	Group
Benelux	Group
Denmark	Group
Dubai	Group
Finland	Group
France	Group
Germany	Group
Great Britain
Hungary	Group
Italy	Group
Norway	Group
Pan-Europe (CP)
Poland	Group
Portugal	Group
Slovakia	Group
South Africa	Group
Spain	Group
Sweden	Group
Switzerland	Group

Hope this help.

Re: Trigger Help

ajaykumar1 — Mon, 08 Jun 2015 17:55:55 GMT

Thanks Massiomo.Its working fine.

In addition with that i have the below scenario need to develop.

Condition 1 : If the Country not contains SWEDEN and DENMARK then mail should go to DEVTEAM@xyz.com

Condtion 2 : If FLAG =0 then the mail to go SALESTEAM@xyz.com

Condition 3 : If above two cases failed then SUPPORT@xyz.com

NOTE 1 : ALL the above conditions based on the MAX DATE selection.

2: Here i choosen select all option in triggers because to show all countries data in the straight table.

WHAT I TRIED :

= if(not wildmatch(Country,'Sweden','Germany'),'DEVTEAM@xyz.com',

if(flag=0,'SALESTEAM@xyz.com','SUPPORTTEAM@xyz.com'))

Please correct me where am wrong and also guide if in case its better to create a new thread.

MORE THANKS,

AJAY

Re: Trigger Help

maxgro — Mon, 08 Jun 2015 19:15:49 GMT

I think the 2 expressions are

number of country Sweden or Germany (for max date); it should be 0 for not Germany and not Sweden

count({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}, Country={Sweden,Germany}>} distinct Country)

value of the flag (for max date)

= only({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}>} flag)

EDIT: new thread?

yes, I think 1 thread, 1 question (maybe with a link to this) or for many questions, all questions at the start of discussion

Re: Trigger Help

ajaykumar1 — Mon, 08 Jun 2015 22:16:29 GMT

Hi Massimo,

I dont want to do any count or sum...whatever the conditions 3 i need to combine at one level like if else.

As per the selection and condition satifisfaction data to be display in text box like whether its devteam or supportteam or salesteam.

thanks,

Ajay

Re: Trigger Help

maxgro — Mon, 08 Jun 2015 22:57:10 GMT

if(count({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}, Country={Sweden,Denmark}>} distinct Country)=0, 'DEVTEAM@xyz.com',

if(only({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}>} flag)=0, 'SALESTEAM@xyz.com',

'SUPPORTTEAM@xyz.com'))

Re: Trigger Help

ajaykumar1 — Tue, 09 Jun 2015 03:20:47 GMT

Thanks you.

I will try to apply the above logic with my original data scenario and will mark the thread.

Thanks,

AJAY

Re: Trigger Help

ajaykumar1 — Tue, 09 Jun 2015 05:44:52 GMT

Hi Massimo...No luck its not working.

The same has been attached here.

Need help in the sample also my requirement is there.

More Thanks,

Ajay

Re: Trigger Help

ajaykumar1 — Tue, 09 Jun 2015 06:14:08 GMT

Hi ,

Any help or hint from anyone?

More Thanks,

Ajay

Re: Trigger Help

maxgro — Tue, 09 Jun 2015 07:30:23 GMT

Sweden and Germany ?

Sweden and Denmark ?

for Sweden and Germany change the expression (bold)

if(count({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}, Country={Sweden,Germany}>} distinct Country)=0, 'DEVTEAM@xyz.com',

if(only({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}>} flag)=0, 'SALESTEAM@xyz.com',

'SUPPORTTEAM@xyz.com'))

the result I get is

Re: Trigger Help

ajaykumar1 — Tue, 09 Jun 2015 10:20:02 GMT

Thanks Massimo.Your right...Its my mistake and sorry for convenience caused earlier.

One thing i want to know how =0 is working here?

What will happen if i kept <> 0 and if i remove the 0?

When am playing with original data with and without 0 am getting some wrong result.

More Thanks for your valueble support.

Ajay

Re: Trigger Help

maxgro — Tue, 09 Jun 2015 11:01:54 GMT

if I understand

One thing i want to know how =0 is working here?

It works as a standard if: if(condition, then, else); condition could be true or false.

if(exp1=0,

'DEVTEAM@xyz.com', // exp1=0

if(exp2=0, // exp1 not = 0

'SALESTEAM@xyz.com', // exp2 = 0

'SUPPORTTEAM@xyz.com' // exp2 not = 0

)

exp1 is the result of the below expression (add a textbox with this expression to see the result of exp1)

=count({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}, Country={Sweden,Germany}>} distinct Country)

exp1 is the number of distinct country for max date and with country = Sweden or Germany

when exp1 is 0 --> DEVTEAM

if(0=0,

'DEVTEAM@xyz.com', // exp1=0

......