topic Re: Can't print the set analysis values? in QlikView

Can't print the set analysis values?

alexpanjhc — Mon, 26 Jan 2026 18:19:17 GMT

All,

I have a few pivot table charts, some expressions used set analysis.

I created a reportin Qlik using these charts.

When I manually print the report, itlooks fine, so i decided to print them in batch(loop by a field name) in publisher.

I found out all the set analysis expressions are either 0 or -

Is there a bug or something that I am missing?

thanks for any suggestions!

Re: Can't print the set analysis values?

jaimeaguilar — Wed, 21 May 2014 22:14:26 GMT

Hi,

you may need to ignore some values in Set Analysis so they don't return zero or null values. I don't know about your data model, however let me tell you an example,

suppose you have a chart with an expression like this:

sum({$<MonthYear={'$(=Monthname(Addmonths(today(),1)))' } >} Sales)

With this expression, you calculate the sales for 1 month ago. However if you select current month and year and send it to print, the expression will be 0, because you need to ignore year and month in your expression, like this:

sum({$<Year=,Month=,MonthYear={'$(=Monthname(Addmonths(today(),1)))' } >} Sales)

The point is that it could be that any selection or reduction done by publisher can be altering your set analysis giving you null / zero results. If you could upload a sample of your application it would be better to help you,

regards

Re: Can't print the set analysis values?

alexpanjhc — Wed, 21 May 2014 22:45:24 GMT

Hi Jaime

Thanks for the suggestions.

I can't upload files in here so I will list my example

I looked at my expression, there are only 2 main expressions like the following

sum ({<[In BTA]={'Y'},[BTA FC]=[FC Name]>} HH_FLAG)

sum({<[FC Name]=,[In BTA]={'Y'},[BTA FC]=[FC Name]>} HH_FLAG)

do you see anything that I should be aware? I do not have and time selections in the dashboard.

Re: Can't print the set analysis values?

jaimeaguilar — Wed, 21 May 2014 23:37:35 GMT

Without seeing the model, the only thing I can think of is that the field that your using to reduce or loop in publisher has no direct relationship with [In BTA] or [FC Name] making that your expressions return null o zero values,

regards

Re: Can't print the set analysis values?

alexpanjhc — Thu, 22 May 2014 13:43:39 GMT

i am only looping on [FC Name]