topic Re: Need help to resolve the set analysis issue in QlikView

Need help to resolve the set analysis issue

alknirmal1 — Wed, 28 Jan 2015 19:52:26 GMT

Hi All,

I have a variable declared in the variable overview tab.

varQuarter1 = $(varReportYear)&'-Q1'

where varReportYear is another variable which is set based on a selection from the list box.

I need to use the variable varQuarter1 inside a set analysis expression..

Expression : Sum(Total {<DateYearQuarter={"$(=varQuarter1)"}>}AdjNOI)

This expression in set analysis is not giving the correct result.. When I hard code a value for varQuarter1 ,its gives me correct result.

Sum(Total {<DateYearQuarter={'2014-Q1'}>}AdjNOI) -- This works fine.

I checked the variables varReportYear,varQuarter1 and both are returning correct values.

Can anyone please help me how to use this variable correctly in setanalysis .

Thanks

Nirmal.

Re: Need help to resolve the set analysis issue

reshmakala — Wed, 28 Jan 2015 20:08:14 GMT

Can you try if this works?

Sum(Total {<DateYearQuarter={$(varQuarter1)}>}AdjNOI)

Re: Need help to resolve the set analysis issue

alknirmal1 — Wed, 28 Jan 2015 20:14:18 GMT

Thanks for your quick reply.

Unfortunately its not working .

Re: Need help to resolve the set analysis issue

alknirmal1 — Wed, 28 Jan 2015 20:15:21 GMT

it give the below error.

Error: Error in set modifier ad hoc element list:

',' or ')' expected

Re: Need help to resolve the set analysis issue

reshmakala — Wed, 28 Jan 2015 20:17:15 GMT

Could you attach a sample QVW?

Just create those two variables and the expression that you have tried so that I can understand where exactly the pblm is

Re: Need help to resolve the set analysis issue

Colin-Albert — Wed, 28 Jan 2015 20:20:53 GMT

Try

Sum(Total {<DateYearQuarter={'$(varQuarter1)'}>}AdjNOI)

Your variable is text not an integer,so needs to be enclosed in single quotes to be interpreted correctly.

Re: Need help to resolve the set analysis issue

alknirmal1 — Wed, 28 Jan 2015 20:25:05 GMT

Thanks for your reply Colin..

It doesn't work

Re: Need help to resolve the set analysis issue

Colin-Albert — Wed, 28 Jan 2015 20:37:16 GMT

Add a text box with. =$(varQuarter1) as the expression, and add a listbox on the DateYearQuarter field.

This should show any differences in the field data and variable data.

Re: Need help to resolve the set analysis issue

reshmakala — Wed, 28 Jan 2015 20:40:40 GMT

Can you try this?

=Sum({<DateYearQuarter={$('varQuarter1')}>}AdjNOI)

I guess this should work.

Re: Need help to resolve the set analysis issue

maxgro — Wed, 28 Jan 2015 20:41:15 GMT

or make a str table with your expression and with an empty label

hover the mouse on the label and watch your expression in the popup

Re: Need help to resolve the set analysis issue

alknirmal1 — Wed, 28 Jan 2015 21:11:28 GMT

Thanks a lot Colin.. It worked fine ..

first time it was my bad .... i made a small mistake and it didn't work.

Now its working perfectly..

Thank you everyone for helping me on this.