Discussion board where members can learn more about Qlik Sense App Development and Usage.
I've seen the P&L table introduced in QlikSense and I have a question. In fact, the table works fine but I need to make a change if it's possible. In fact, I need to develop this table like a pivot table in QlikView so with the dimension that have a + button on the right and with some subtotals. I have seen the one developed by VizLib and I would try to achieve something similar. Is there an extension that I could use?
Using P&L table you can achieve the functionality of VizLib P&L table but it depends. Vizlib has some additional features like formatting, exporting to excel and conditional expansion, which will be challenging to achieve in P&L table.
if you can specify in detail what is the output you are looking for, we can see if its feasible or not....
Thanks for the reply. In fact, what I'm trying to achieve is the conditional expansion. Because the structure of my dimension analysis is based on 4 different level starting from Level 1 which is composed by Assets, Liabilities&Equity, Net margin, Expensed and then going deeper I have other level of analysis composed by the sublevels of the previous ones.
So what I'm trying to achieve is the indentation of the rows like the one present in Pivot tables. Is there a way to achieve this goal?
Thanks and kind regards,
For P&L Pivot table you can use only 2 dimension 1 vertical and 2nd horizontal and the rest you can add 8 measures. in total you can 10 columns in P&L table.
refer the P&L table details from qlik: https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/Visualizat...
additional references for P&L table:
Additionally, i see you have posted screen shot output and i think this is possible to do in Qlik sense native pivot. you can also add indentation
Hi Sammy, thanks for your kind reply.
I've seen the links about "Top 10 Viz..." and in fact what I'm trying to achieve is the
"Tree View" present on this link: https://community.qlik.com/t5/Documents/Top-10-Viz-tips-Part-II/ta-p/1642330?lightbox-message-images...
In fact I know that the Pivot table has this native feature but since I'm trying to create a table that has to be shown on mobile the Pivot Table header takes up to much space. So I've seen on this link that there is a way to hide the pivot buttons using this css code:
display: none !important
But i don't know where I have to put it or how to use it.
Is there a way to achieve my goal without using this code? If not could you please tell me how to use it?
I've tried different solution with JS, but since I don't know how Java works I've not been able to achieve my goal. Is there a way to improve the visualization of pivot tables (by eliminating pivot buttons) without using JS?
The Java script needs to be added in the CSS of the Theme. You can create / Edit the QlikSense Theme and add the button code in CSS. i can demo with QS desktop version. In the Extensions folder of QS desktop create a folder and give this folder a name say "CUSTOM1"
Then in this folder you need to add QEXT, CSS and JSON file, refer the attachment. In the CSS file you can add the code and save it. then you can apply this theme to QVF file and you will get the required result.
display: none !important
you can try other pivot table extensions to achieve this.