topic Re: Set Analysis - how to use variable vlaue inside set analysis in QlikView

Set Analysis - how to use variable vlaue inside set analysis

Sat, 11 Oct 2014 13:05:47 GMT

Hi Qv,

I have a expression like this Sum ({<$(vSegment) ={'3. Due Later'}>} Sales) and vSegment variable is working fine but the it showing syntax error at {'3. Due Later'}

what is the correct syntax to use variables contains the field names inside set analysis?

thanx

Re: Set Analysis - how to use variable vlaue inside set analysis

jyothish8807 — Sat, 11 Oct 2014 14:29:10 GMT

Hi Swathi,

How do want to use this variable?

baisic format is:

sum({$<[Field]={'$(=vSegment)'}>}Sales)

or are you trying to compare the text with in the variable?

Regards

Re: Set Analysis - how to use variable vlaue inside set analysis

jyothish8807 — Sat, 11 Oct 2014 14:33:10 GMT

Hi,

Try like this:

Var='ABC'

=if($(Var)='ABC',Sum(sales))

Regards

Re: Set Analysis - how to use variable vlaue inside set analysis

khasimvali85 — Sat, 11 Oct 2014 14:44:49 GMT

Hi Swathiraj,

can explain briefly i couldn't under stand, can send data in excel format.

I think 3.Due Later is Column name right? if it is column name use like this

=Sum({<3.Due Later={'$(=vSegment)'}>} Sales)

=Sum({<Due Later={'$(=vSegment)'}>} Sales)

Regards,

Khasim.