Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zenobendi
Contributor III
Contributor III

P&L Table Qliksense - QlikView

Hi,

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?

Thanks,

Zeno

1 Solution

Accepted Solutions
Sammy_AK
Creator II
Creator II

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. 

.qv-pt-meta-button {

     display: none !important

}

you can try other pivot table extensions to achieve this. 

Theme reference: https://community.qlik.com/t5/Qlik-Design-Blog/How-to-create-a-custom-theme-in-Qlik-Sense/ba-p/14719...

https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/Extensions/Content/Sense_Extensions/C...

 

 

View solution in original post

7 Replies
Sammy_AK
Creator II
Creator II

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....

zenobendi
Contributor III
Contributor III
Author

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.

zenobendi
Contributor III
Contributor III
Author

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,

 

Zeno

Sammy_AK
Creator II
Creator II

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:

https://community.qlik.com/t5/Documents/Top-10-Viz-tips-Qonnections-2019-Part-I/ta-p/1580174

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 

references: https://community.qlik.com/t5/QlikView-App-Dev/Indentation-in-straight-table/td-p/975293

https://community.qlik.com/t5/QlikView-App-Dev/How-to-indent-expression-labels/m-p/811475

 

zenobendi
Contributor III
Contributor III
Author

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:

.qv-pt-meta-button {

     display: none !important

}

But i don't know where I have to put it or how to use it.

 https://community.qlik.com/t5/Documents/Top-10-Viz-tips-part-III-QlikWorld-2020/ta-p/1679607?lightbo...

Is there a way to achieve my goal without using this code? If not could you please tell me how to use it?

 

Thanks 

Zeno

zenobendi
Contributor III
Contributor III
Author

Hi Sammy, 

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?

Thanks,

Zeno

Sammy_AK
Creator II
Creator II

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. 

.qv-pt-meta-button {

     display: none !important

}

you can try other pivot table extensions to achieve this. 

Theme reference: https://community.qlik.com/t5/Qlik-Design-Blog/How-to-create-a-custom-theme-in-Qlik-Sense/ba-p/14719...

https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/Extensions/Content/Sense_Extensions/C...