topic Error on writing if condition to filter multiple fields using "and" operator in script in QlikView

Error on writing if condition to filter multiple fields using "and" operator in script

Anonymous — Tue, 14 Feb 2017 04:33:58 GMT

Example:

if(country='A' and state='B' and city='C' , sum(sales)/ count(city='C'), sum(sales))

Thanks in advance.

Re: Error on writing if condition to filter multiple fields using "and" operator in script

Chanty4u — Tue, 14 Feb 2017 10:32:10 GMT

its working for me

Re: Error on writing if condition to filter multiple fields using "and" operator in script

sunny_talwar — Tue, 14 Feb 2017 10:33:12 GMT

Are you using this in the script? I don't see anything wrong with the if statement, but if you are using this in the script, you might need a group by statement in your table load. May be provide more information to help you better

Re: Error on writing if condition to filter multiple fields using "and" operator in script

Anonymous — Tue, 14 Feb 2017 16:24:33 GMT

yes i am using this in the script , tried using group by too. correct me if i am wrong in writing the statement.

Example:

if(country='A' and state='B' and city='C' , sum(sales)/ count(city='C'), sum(sales)) as A sales

resident table

group by Country;

Re: Error on writing if condition to filter multiple fields using "and" operator in script

Anonymous — Tue, 14 Feb 2017 16:27:00 GMT

yeah its working for me too in the front end but not in the script.

Re: Error on writing if condition to filter multiple fields using "and" operator in script

sunny_talwar — Tue, 14 Feb 2017 16:39:29 GMT

Not sure what all dimensions you have, but you at least need country, state and city because they are not aggregated

if(country='A' and state='B' and city='C' , sum(sales)/ count(city='C'), sum(sales)) as A sales

resident table

group by Country, state, city;

Re: Error on writing if condition to filter multiple fields using "and" operator in script

Anonymous — Tue, 14 Feb 2017 16:54:13 GMT

Thanks a lot sunny, its working now with group by Country, state, city.