Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ajaykumar1
Contributor III

Trigger Help

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 :

'(Austria|Benelux|Denmark|Dubai|Finland|France|Germany|Hungary|Italy|Norway|Poland|Portugal|Slovakia|Spain|Sweden|Switzerland|*South*|*Great*|*Pan*|*Senegal*)' 

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

More Thanks in advance,

Ajay

1 Solution

Accepted Solutions
MVP
MVP

Re: Trigger Help

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

      ......


13 Replies
awhitfield
Esteemed Contributor

Re: Trigger Help

Hi ajay

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

HTH

Andy

MVP
MVP

Re: Trigger Help

if you have some space

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

santhoo_san
Contributor II

Re: Trigger Help

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'

  

CountryGrpCountry
AustriaGroup
BeneluxGroup
DenmarkGroup
DubaiGroup
FinlandGroup
FranceGroup
GermanyGroup
Great Britain
HungaryGroup
ItalyGroup
NorwayGroup
Pan-Europe (CP)
PolandGroup
PortugalGroup
SlovakiaGroup
South AfricaGroup
SpainGroup
SwedenGroup
SwitzerlandGroup

Hope this help.

ajaykumar1
Contributor III

Re: Trigger Help

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



MVP
MVP

Re: Trigger Help

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

ajaykumar1
Contributor III

Re: Trigger Help

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

MVP
MVP

Re: Trigger Help

=

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'))

ajaykumar1
Contributor III

Re: Trigger Help

Thanks you.

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

Thanks,

AJAY

ajaykumar1
Contributor III

Re: Trigger Help

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

Community Browser