topic Re: SET expression required in QlikView

SET expression required

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

Hi,

I have a data like as below

Budget	A Project	B Project	C Project
0.13	A
0.26		B
0.33			C
0.49	A
0.7		B

I need to display in a text object the sum of Budget of the Project A and Project B that is 1.58 (excluding Project C)

How to achieve it...

Thanks in advance

Regards,

Yoganantha Prakash G P

Re: SET expression required

pooja_prabhu_n — Tue, 04 Sep 2018 10:13:28 GMT

Hi,

You can try something like this:

=Sum({<[A Project]={'*'}-{''}>+<[B Project]={'*'}-{''}>}Budget)

Thanks,

Pooja

Re: SET expression required

Anonymous — Tue, 04 Sep 2018 10:32:02 GMT

Hi Use this expression in text object

=Sum({<[A Project]={'A'}>}Budget) + Sum({<[B Project]={'B'}>}Budget)

Re: SET expression required

boraste-sagar — Tue, 04 Sep 2018 10:34:52 GMT

Hi Yoganatha

try this

=Sum({<[A Project]={'A'}>}Budget) + Sum({<[B Project]={'B'}>}Budget)

Re: SET expression required

gawalimegha — Tue, 04 Sep 2018 10:44:52 GMT

Hello Yoganantha,

Use simply this.

=sum( {<[A Project]={'A'}> + < [B Project]={'B'}>} Budget )

Re: SET expression required

yoganantha321 — Tue, 04 Sep 2018 10:49:03 GMT

Hi all,

I have given wrong data set.

Kindly find the new one

Budget	A Project	B Project	C Project
0.13	1
0.26		1
0.33			1
0.49	2
0.7		2
0.5	3
0.6		3

Re: SET expression required

yoganantha321 — Tue, 04 Sep 2018 10:49:26 GMT

Hi Pooja,

I have given wrong data set.

Kindly find the new one

Budget	A Project	B Project	C Project
0.13	1
0.26		1
0.33			1
0.49	2
0.7		2
0.5	3
0.6		3

Re: SET expression required

pooja_prabhu_n — Tue, 04 Sep 2018 10:59:19 GMT

Hi,

Same expression works for this data set as well.

=Sum({<[A Project]={'*'}-{''}>+<[B Project]={'*'}-{''}>}Budget)

Thanks,

Pooja

Re: SET expression required

yoganantha321 — Tue, 04 Sep 2018 11:03:44 GMT

it is not working Pooja

Re: SET expression required

gawalimegha — Tue, 04 Sep 2018 11:18:02 GMT

Hello Yoganantha,

Try this one.

=sum( {<[A Project]={">=1"}> + < [B Project]={">=1"}>} Budget )

Re: SET expression required

pooja_prabhu_n — Tue, 04 Sep 2018 11:23:01 GMT

What is the error you are getting?

If possible please share the sample app.

Thanks,

Pooja

Re: SET expression required

trdandamudi — Tue, 04 Sep 2018 12:53:56 GMT

Please check your total and it should be 2.68 and not 1.58. The below expression will give you 2.68 which is correct:

=sum( {<[A Project]={">0"}> + < [B Project]={">0"}>} Budget )

Re: SET expression required

Snehal_Nabar_Amey — Tue, 04 Sep 2018 13:44:18 GMT

Hello,

Please try this.

sum( {<[A Project]={'1','2','3'}>}Budget) + sum({<[B Project]={'1','2','3'}>}Budget )

Regards,

Snehal

Re: SET expression required

sasiparupudi1 — Tue, 04 Sep 2018 14:06:21 GMT

Try

=Sum(If(Len(trim([A Project])),Budget))+Sum(If(Len(trim([B Project])),Budget))-Sum(If(Len(trim([C Project])),Budget))

Re: SET expression required

vishus913 — Tue, 04 Sep 2018 14:13:18 GMT

Hi,

PFA the qvf, maybe this may work

Thanks

Vikas

Re: SET expression required

yoganantha321 — Wed, 05 Sep 2018 09:28:23 GMT

hi Vikas,

I cannot open the file. can you send the same in qvw file format

Re: SET expression required

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

Try this :

Sum({<AProject={"A"}>+<BProject={"B"}>}Budget)

Re: SET expression required

vishus913 — Wed, 05 Sep 2018 10:16:07 GMT

Hi i have no qvw ,

try this expression,

Sum({<[A Project]=p([A Project])>+<[B Project]=p([B Project])>}Budget)

it worked well in the qvf

thanks

regards,

vikas

Re: SET expression required

yoganantha321 — Wed, 05 Sep 2018 10:29:43 GMT

thanks