Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaykumar1
Creator III
Creator 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

13 Replies
ajaykumar1
Creator III
Creator III
Author

Hi ,

Any help or hint from anyone?

More Thanks,

Ajay

maxgro
MVP
MVP

Sweden and Germany ?

Sweden and Denmark ?

1.png

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

2.png




ajaykumar1
Creator III
Creator III
Author

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

maxgro
MVP
MVP

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

      ......