topic Re: Variable in QlikView

Variable

upaliwije — Fri, 23 Feb 2018 04:27:33 GMT

Hi Friends

I have created a varaiable as shown below

vPaid=RangeSum({<CLA_CODE={"SS"}>},LBP_CLAIMS_PAID,-EXCESS)

But this does work. Have I made any error? Kindly advise me and correct me

Re: Variable

upaliwije — Fri, 23 Feb 2018 04:39:13 GMT

Sorry , This variable does not work

Re: Variable

jonathandienst — Fri, 23 Feb 2018 04:39:24 GMT

RangeSum() is not an aggregation function that allows section access. I assume you mean Sum()

vPaid = Sum({<CLA_CODE={"SS"}>} LBP_CLAIMS_PAID - EXCESS)

vPaid = Sum({<CLA_CODE={"SS"}>} RangeSum(LBP_CLAIMS_PAID, -EXCESS))

Re: Variable

tresB — Fri, 23 Feb 2018 04:53:20 GMT

I assume you mean Set Analysis (and not section access), right?

Re: Variable

upaliwije — Fri, 23 Feb 2018 05:03:23 GMT

Thanks

I have done as you suggested. But when I enter the vairavle in pivot table It returns null value as shown below

Re: Variable

upaliwije — Fri, 23 Feb 2018 05:05:20 GMT

I want to create a variable "vPaid" and apply the same in an expression in apivot table

sum($(vPaid)

That is my requirement pls.

Re: Variable

tresB — Fri, 23 Feb 2018 05:08:41 GMT

Try without sum() in the expression, like: =$(vPaid)

Re: Variable

jonathandienst — Fri, 23 Feb 2018 05:11:40 GMT

You can't wrap a sum() around a variable that already contains a sum. Just use $(vPaid) as the chart expression without the sum() wrapper.

Re: Variable

upaliwije — Fri, 23 Feb 2018 05:24:07 GMT

Thanks Dienst,

I works that way. But I want write a another expression as shown below

({<PRL_PTY_CODE={'INP'}>}$(vPaid)) Then It does not work Seek Your advise please.

Re: Variable

jonathandienst — Fri, 23 Feb 2018 11:04:52 GMT

({<PRL_PTY_CODE={'INP'}>}$(vPaid)) ??

I dont know what you are trying to achieve. As a rule, I would not convert expressions to variables until I have got the expressions working correctly. Defining variables too early makes development more difficult.