Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.
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
i am only looping on [FC Name]