Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
SomeDudeAtWork
New Contributor III

And

Hi all,

Is there a suitable replacement for the AND formula we would have used in excel? I've tried to add AND, and it goes blue and seems okay, until clicking apply, then it just states that And is not a valid function.

Essentially i have more than 2 parameters in my If statement, and was thinking perhaps ';' could work as it's similar.

Thanks

Labels (1)
6 Replies
Partner
Partner

Re: And

Hi,

Do you use this in the Data Manager and in combination with an IF statement? This is sadly not possible..

You can try the script editor. If you need help with this, just post the problem.

Jordy

Climber

Work smarter, not harder
SomeDudeAtWork
New Contributor III

Re: And

Essentially im trying to create a productivity trend for different markets, but each market has a different billable number, meaning each market has a unique parameter. MEaning German team cold be Captured time/(days worked*420 minutes a day* billable for 10 people). But i have several markets to do this with, and just want to use 1 line graph to project this when selecting that markets button, i can do for overall, and per city but not per market.

Partner
Partner

Re: And

That is clear, but where are you trying to make this AND statement, is that in the Data Manager, Script Editor or in the front-end?

Jordy

Climber

Work smarter, not harder
SomeDudeAtWork
New Contributor III

Re: And

This would be on the front end, i dont have access to the overall application.

Highlighted
SomeDudeAtWork
New Contributor III

Re: And

What if i tried (Sum(Captured_Time))/ ((Days worked*420)*7) but based off a selection? Like if({Processing_Team ='German']

Partner
Partner

Re: And

You can try something like this:

IF(Processing_Team = 'German', Sum(Captured_Time) / ((Days worked*420)*7), [Other conditions for other teams])

Do you  maybe have some sample data to test?

Jordy

Climber

Work smarter, not harder