Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
i have an issue to present the data correctly aligned (s. attachment) in NP PixelPerfect.
The report takes the date (i.e. "Stand: 11.12.19") and calculates a period of a year back (12.12.18 - 11.12.19 => 2019). This range is saved in QS in vPeriod and fills automatically another variable (vPeriodVJ) with the range a year before (12.12.17-11.12.18 => 2018). All the fields in the attachment are calculated with set analysis on these variables in formulas in the NP Designer. I've created an advanced filter for the whole range on the year field, but I want to have the calculation-columns of 2018 behind the ones of 2019 placed.
Does anybody have an idea to merge my "two tables"? Thanks in advance
Hi @Gerdinho22
If I understand your question correctly perhaps you can use set analysis in conjunction with an new straight table chart.
Of course you would need to apply your advanced filters to enable the ranges as needed.
How it works in the template editor
Report output attached
Hopefully this is something that you might be able to leverage to achieve the result you need.
Kind regards...
Hi,
thanks for the response. In the meantime, I worked on a similar solution like yours and it was solved with set analysis, i.e. sum({<Datum={'>=01.01.2018<=31.01.2018'}>}[$(vQuelle)]). Now I have over 100 formulas and more than 200 labels.
However, I`m not happy with it, because I´ll have to adjust every formular year by year. Maybe it is possible to create a variable, which takes the current date from my selection and calculates the needed range?!
I will work on it and would post my success into this thread, but so far it is done 🙂
Thanks everyone
Hi @Gerdinho22
If I understand your question correctly perhaps you can use set analysis in conjunction with an new straight table chart.
Of course you would need to apply your advanced filters to enable the ranges as needed.
How it works in the template editor
Report output attached
Hopefully this is something that you might be able to leverage to achieve the result you need.
Kind regards...
Hi,
If you mean that you would like to place two tables side-by-side I suggest to give a check at the post https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Side-by-Side-Tables-in-One-Band-in-PixelPer...
Best Regards,
Ruggero
Hi,
thanks for the response. In the meantime, I worked on a similar solution like yours and it was solved with set analysis, i.e. sum({<Datum={'>=01.01.2018<=31.01.2018'}>}[$(vQuelle)]). Now I have over 100 formulas and more than 200 labels.
However, I`m not happy with it, because I´ll have to adjust every formular year by year. Maybe it is possible to create a variable, which takes the current date from my selection and calculates the needed range?!
I will work on it and would post my success into this thread, but so far it is done 🙂
Thanks everyone