Pixel Pexfect formatting issue

vitaliichupryna — Sat, 16 Nov 2024 03:05:21 GMT

Hi,

I'm working on the Pixel Perfect report and have two problems with formatting:

I added tables from QlikSense and those tables contains measures with Set analysis, I should send report to a few users and tables for some of them from time to time haven't data. I decided add formatting condition to hide tables if they are empty, but it doesn't work.

I tried to use different conditions:

Not IsNullOrEmpty([AAData_Theme_Level])

[DataSource.RowCount]>0

But they doesn't work. What can be the reason of issue?

Second problem with formulas. I have KPI sheet in the report and as some users haven't data they should see 0 in the KPI, but instead of that report shows empty space. My formula is:

sum({<$(vL_BD_of_PM), [StaticData.ActiveFlag] = {1}>}[StaticData.Zero hits])

I tried add if statements, but it also doesnt't work:

If isnull(sum({<$(vL_BD_of_PM), [StaticData.ActiveFlag] = {1}>}[StaticData.Zero hits]), '0',

sum({<$(vL_BD_of_PM), [StaticData.ActiveFlag] = {1}>}[StaticData.Zero hits]))

Thanks,

Vitalii

Re: Pixel Pexfect formatting issue

Frank_S — Thu, 11 Jul 2019 19:38:37 GMT

@vitaliichupryna

It's not clear if you are using Qlik Sense or PixelPerfect formatting conditions.

To show/hide formatting using PixelPerfect conditions, you can use the following tutorial:

https://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/PixelPerfectReports/Manage-Conditional.htm
For a video on this topic, please check out this video: Using conditional formatting in a PixelPerfect report - Qlik NPrinting

Regarding your KPI, check to ensure it is a visualization that is actually supported for use with NPrinting here:

https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Visualizations/create-visualization-extensions.htm

If it is supported KPI visualization, then I would suggest starting a support request...but first please ensure the visualization (measure in the KPI) is definitely working as designed within your Qlik Sense app first before doing so.

Kind regards...

topic Pixel Pexfect formatting issue in Qlik NPrinting

Pixel Pexfect formatting issue

Re: Pixel Pexfect formatting issue