topic Re: SET expression in QlikView

SET expression

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

I have table with two column as shown in the vomeproject.png image.

I have used a set expression of =sum({<VomeProject= {'*'}>}Budget) in text object which is showing 0 instead of 0.32 .

Anybody help me in this!

I have attached a data source along with this.

Regards,

Yoganantha Prakash G P

Re: SET expression

Anil_Babu_Samineni — Wed, 05 Sep 2018 09:36:06 GMT

Can you share your default variables?

Re: SET expression

vishweshwarisun — Wed, 05 Sep 2018 09:36:23 GMT

Hi,

try this expression

=Sum({<VomeProject={*}>}Budget)

Re: SET expression

yoganantha321 — Wed, 05 Sep 2018 09:38:17 GMT

that i was i used vishweshwari as i mentioned above

Re: SET expression

vishweshwarisun — Wed, 05 Sep 2018 09:39:15 GMT

just remove the single quotes of *

Re: SET expression

yoganantha321 — Wed, 05 Sep 2018 09:39:45 GMT

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

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

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

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

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Re: SET expression

yoganantha321 — Wed, 05 Sep 2018 09:41:46 GMT

thanks it is working now.

Re: SET expression

vishweshwarisun — Wed, 05 Sep 2018 09:43:02 GMT

here is the attachment

Re: SET expression

Anil_Babu_Samineni — Wed, 05 Sep 2018 10:34:47 GMT

How remove Single Quote helping here? Not understand why this got answered. I got answer even using your direct expression without removing anything. PFA