topic Re: Chart not Displaying any Data in PixelPerfect Report in Qlik NPrinting

Chart not Displaying any Data in PixelPerfect Report

dnl_kln — Thu, 19 Oct 2023 12:39:14 GMT

Hello,

I'm kind of frustrated right now, since I'm trying to display some data from a simple table in my PixelPerfect native Chart. Data Source is QLIK Sense Server.

It simple does'nt work. I tried everything, including:

Try another Table
Rename Colums
Rename Dimensions
Disconnecting Master-Data and working directly with the formula

I can choose the table as Data source in the Chart-Wizard - by previewing the report, the chart ist empty, even the x-axis ist displaying wrong values.

Does anybody know a trick that I'm missin?

Re: Chart not Displaying any Data in PixelPerfect Report

Lech_Miszkiewicz — Thu, 19 Oct 2023 12:51:32 GMT

1. Have you followed steps from https://help.qlik .com on how to build pixel perfect charts?

2. Does you table object produce any data in other templates (excel)-maybe there are selections required for data to be shown

3. What are the data types you try to display as dimension and values. Sometimes having dual or funny number format confuses pixel perfect which does not recognise it.

Hard to say more without investigating your particular example.

Re: Chart not Displaying any Data in PixelPerfect Report

dnl_kln — Thu, 19 Oct 2023 13:21:33 GMT

Thanks for your quick reply!

1. Yes - I even followed the instructions in their youtube tutorial.

2. I just tested it in Excel - it's producing data (see attached screenshot).

3. Dimension ist "CalendarMonthName" from my MasterCalendar (AutoCalendar)

Value ist "Sum( { $< [CalendarDate.autoCalendar.YearsAgo]={0} > } [Angebote.Angebotssumme])" - simple sum-Formula for the actual year. Number Format ist "Currency" ("#.##0,00 €;-#.##0,00 €").

Re: Chart not Displaying any Data in PixelPerfect Report

Lech_Miszkiewicz — Thu, 19 Oct 2023 21:59:08 GMT

2 things.
1. The autocalendar could be a problem here. It does not create actual fields and to be honest i never use it in my apps for bunch of other reasons and i will never do.
I would definitely start by creating proper field for such reason

2. Money format can be issue - have you tried creating just simple object with number format. You can then apply money format in Nprinting.

Re: Chart not Displaying any Data in PixelPerfect Report

dnl_kln — Mon, 23 Oct 2023 10:06:05 GMT

I tested your suggestions by trying a chart with one simple dimension (numeric values) and a simple sum function ( Sum( { $< [Buchungsjournal.Calc_Flag]={1} > } [Buchungsjournal.Saldo_Buchung] ) ).

When selecting the argument (p.e. "Konten-Nr") and afterwards selecting values, the selected argument is still present in the list. In the Youtube-Tutorial, die Argument.Item disappears from the selectable Values list.

The chart still does not display data.

I even updated the whole qlik environment up to the latest version (Qlik Sense and N-Printing).

What else can I do?

Re: Chart not Displaying any Data in PixelPerfect Report

dnl_kln — Mon, 23 Oct 2023 11:59:35 GMT

I got it - had to do with the autocalendar-Dimension you suggested. After changing it from "monthname" to "month(CalendarDate)" it all worked.

Thanks for your help!