topic Re: Setanalysis to make field constant in QlikView

Setanalysis to make field constant

Thu, 05 Feb 2015 09:50:17 GMT

Hi Experts,

Right now I am using below expression:

Sum(Trad_UNREALIZED_PL) + If(Trad_PERIOD='P0',0,RangeSum(Above(sum(Trad_UNREALIZED_PL) ,RowNo()-1)))

And my question is when ever I select ex:Period=P1 then P0 and P1 should be displayed so P0 should be displayed always without disturbing the results.

Could some one please help me?

Thank you

Re: Setanalysis to make field constant

avinashelite — Thu, 05 Feb 2015 10:03:37 GMT

as per my understanding the period selection show not affect the chart data?? if so try like this:

Sum(Trad_UNREALIZED_PL) + If(Trad_PERIOD='P0',0,RangeSum(Above(sum({<Trad_PERIOD=>}Trad_UNREALIZED_PL) ,RowNo()-1)))

Re: Setanalysis to make field constant

Thu, 05 Feb 2015 10:20:13 GMT

Hi Avinash,

Not that one. I will explain.

Added 2 attachments.

1 is current one.

2 is, which I am looking for.

Thank you.

Re: Setanalysis to make field constant

avinashelite — Thu, 05 Feb 2015 10:26:19 GMT

try something like this:

Sum(Trad_UNREALIZED_PL) + If(Trad_PERIOD='P0',0,if(getfeildselction(Trad_PERIOD)='P1',angeSum(Above(sum({<Trad_PERIOD='P0,P1'>}Trad_UNREALIZED_PL) ,RowNo()-1)))

if not working please share your app

Re: Setanalysis to make field constant

Thu, 05 Feb 2015 10:45:16 GMT

Its a Huge application Avinash.

Re: Setanalysis to make field constant

avinashelite — Thu, 05 Feb 2015 10:46:10 GMT

get the sample data raj, with that chart.

Re: Setanalysis to make field constant

avinashelite — Thu, 05 Feb 2015 10:51:25 GMT

see the attached eg

Re: Setanalysis to make field constant

Thu, 05 Feb 2015 11:01:38 GMT

Hi Avinash, Could you please paste the images, if you don't mind. I don't have license to open other QVWs. Thank you

Re: Setanalysis to make field constant

avinashelite — Thu, 05 Feb 2015 11:55:32 GMT

Please see the attached image, according to your requirement I have a take some test data and tested the expression and its working fine.

If you got the answer please mark this thread as answered

Re: Setanalysis to make field constant

Thu, 05 Feb 2015 13:10:10 GMT

Hi Avinash,

Its perfectly alright but in my case I have P0 to P15 periods.

So Could you please suggest me in case?

Re: Setanalysis to make field constant

avinashelite — Thu, 05 Feb 2015 13:12:26 GMT

means?? for each selection you want different periods to be shown??

can you please explain me what your looking for

Re: Setanalysis to make field constant

Thu, 05 Feb 2015 13:44:00 GMT

For Ex:

If I select P1 then

and If I select P2 then

and If I select P3 then

Like this.

Thanks Avinash for helping me.

Re: Setanalysis to make field constant

Thu, 05 Feb 2015 14:18:06 GMT

Hi Raj,

Please create a new field PeriodNo to stored numeric representation of the period column..

eg P1 = 1,P2 = 2 ......

and then used the set expression like

sum({<PeriodNo={'<=$(=Max(PeriodNo))'},Period=>}yourcolumn) for Sum of Each Row

and

sum({<PeriodNo={'<=$(=Max(PeriodNo))'},Period=>}B) + RangeSum( Above(sum({<PeriodNo={'<=$(=Max(PeriodNo))'},Period=>}B)))
for cumulative sum.

Regards

Nandkishor

Re: Setanalysis to make field constant

avinashelite — Thu, 05 Feb 2015 14:57:28 GMT

Hi Raj,

After lot of R&D i found the soultion.

its dynamic use this expression:

if(GetSelectedCount(Product)=0,sum(AMOUNT),sum({<Product={'P0',"=Product=GetFieldSelections(Product)"}>}AMOUNT))

its working perfectly. Thanks for the innovative question it took almost 2 hrs

Re: Setanalysis to make field constant

avinashelite — Thu, 05 Feb 2015 14:59:45 GMT

Hey if you got the answer please mark it as answered

Re: Setanalysis to make field constant

Fri, 06 Feb 2015 05:50:19 GMT

Hi Avinash,

Let me test it.

Thanks for your help.

Re: Setanalysis to make field constant

avinashelite — Fri, 06 Feb 2015 06:04:58 GMT

sure Raj, if you have any issue let me know

Re: Setanalysis to make field constant

avinashelite — Fri, 06 Feb 2015 12:34:10 GMT

Hi Raj,

Did this issue got resolved??? or still any issues

Re: Setanalysis to make field constant

Fri, 06 Feb 2015 21:04:31 GMT

Sorry Avinash, I couldn't get time to check this as I was stuck on other issues and even you helped me on those also.

I knew that you have spent much time on this issue, I can't forget it. I am sure that I will check this.

Re: Setanalysis to make field constant

avinashelite — Sun, 08 Feb 2015 09:11:18 GMT

sure bro