Unlock a world of possibilities!
now and discover the exclusive benefits awaiting you.
Apr 19, 2022 5:26:09 AM
Sep 25, 2017 9:31:25 AM
Suppose that you have a Qlik straight table with the columns Year, Month and sales like the following:
and you want to obtain a PixelPerfect chart with a line for each year and details by month like the following:
Nice. Is it also possible to use the max of year and the max of year -1 instead of static values?
No, it is not possible to insert a formula instead of a fixed value.
Like i said - it is not possible to have 2 dimensions which in this case is a main factor.
My suggestion is more flexible as you can create measure for YEAR and measure for YEAR -1 in Qlik and have them dynamic on Qlik side.
Other steps would be similar to Ruggero's with only difference that in my solution you do not have to apply filters in PixelPerfect charts as they will be already filtered by set analysis expression.
PS. Ruggero - do you thinkg you could ask R&D to consider building multidimensional charts in Pixel Perfect (as a feature request)? That would apply to multidimensional bar charts or stacked bar charts with dynamic stacks etc
Of course, I can ask!
Good Idea to make two measures. But you also have static names for the series.The use of variables would be niceWouter
Thanks for the article and alternative solutions! I also work with set analysis in Qlik for the single expressions. The major problem in both solutions is the name displayed in the legend. It's not dynamic.
Is there a solution for displaying the field value in the legend?
Thank you so much.
Your request is not clear to me. Legend is for the categories of data so you see the category names there.
Maybe you need to use Point Labels to add the values of the point in the chart.
Let me know if this helps.
Thanks for answering!
In the first screen shot we can set an expression for the label.
This variabel displays in this case the name of the 5 portfolios selected simulating a second dimention with set analysis.
In the PixelPerfect Template we can set only a fixed name for the series for the same chart comming from Qlik for each expression.
The final result is shown below. The legend shows only the fixed names like in the series but not the result of the expressions like in the original Qlik Sense chart.
Is there a way to display the names of the expressions in PxP with an expression or variable?
Can we overwrite the labels with a script where we can lookup for the variable results?
Thanks for your reply!