topic Re: reg: E() in set analysis in QlikView

reg: E() in set analysis

pavansonu99 — Wed, 25 Nov 2020 16:16:04 GMT

hi,

My data is like this

country sales

india 1000

china 1400

usa 1600

uk 1300

germany 1900

i want sum of sales of countries but i want to exclude countries 'china' and 'UK'

how can we write set analysis in the expression using E() and without using E()

Re: reg: E() in set analysis

rupamjyotidas — Fri, 30 Sep 2016 16:03:37 GMT

Probably this will help

Sum( {<Country -={China,UK}>} Sales)

Re: reg: E() in set analysis

miguelbraga — Fri, 30 Sep 2016 16:10:03 GMT

Hey there,

Have you read this document?

https://community.qlik.com/docs/DOC-4951

Best regards,

D.A. MB

Re: reg: E() in set analysis

sunny_talwar — Fri, 30 Sep 2016 16:10:21 GMT

With E you can try this:

Sum({<Country = e({<Country = {'China', 'UK'}>})>} sales)

Sum({<Country *= e({<Country = {'China', 'UK'}>})>} sales)

Re: reg: E() in set analysis

miguelbraga — Fri, 30 Sep 2016 16:22:40 GMT

You can also try this out:

Expressions:

Without E():

Sum( {$<country -= {"china","uk"}>} sales)

With E():

Sum({$<country = e({<country = {"china", "uk"}>})>} sales)

Script:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LOAD * INLINE [

country, sales

india, 1000

china, 1400

usa, 1600

uk, 1300

germany, 1900

];

Check my solution in the attached qvw file

Best regards,

D.A. MB

Re: reg: E() in set analysis

Fri, 30 Sep 2016 19:00:47 GMT

try this please

=sum({<Country=e(1<country={‘china’,’uk’}>})>}sales)

Re: reg: E() in set analysis

Fri, 30 Sep 2016 19:08:25 GMT

corrected code

try this please

=sum({<country=e({1<country={"china","UK"}>})>}sales)

Re: reg: E() in set analysis

Fri, 30 Sep 2016 19:22:04 GMT

without e()

=sum({<country={"*"}-{"uk","china"}>}sales)

try this please