Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

alexpanjhc
Valued Contributor

Can't print the set analysis values?

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!

4 Replies
jaimeaguilar
Valued Contributor II

Re: Can't print the set analysis values?

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

alexpanjhc
Valued Contributor

Re: Can't print the set analysis values?

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.

jaimeaguilar
Valued Contributor II

Re: Can't print the set analysis values?

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

alexpanjhc
Valued Contributor

Re: Can't print the set analysis values?

i am only looping on [FC Name]

Community Browser