Hi. That is all about how you structure the data model, it is just hierarchical dimension values. I think I loaded a sample application on Github with the extension. By the way, I no longer work for qlik, and at the moment do nothave time to maintain this extension. But, like any extension it is just web code and you can get anyone to enhance it if needed.
Love the extension Lee. Is there any way to have one column formatted with a $ sign? I want a column for quantity and another for value, with only the value column being formatted with the dollar sign.
Yes, this is possible. I have done this in some apps i have built to use percentage formatting in one column. For the dimension you will need some field with a list of possible values like "Actual", "Budget", "Variance", "Variance %". Then in each measure you need to have an if() statement that checks for the existence of % in the value and use a different format expression with the num() function. Of course in your case you will use $ rather than % to trigger the different format.
I got that working, thanks a lot. A new issue has come up and it may be from the September release. Now the columns with a % symbol no longer show as a percent and columns with a $ symbol show a $ symbol, but after the number. This is with reports that are not using the num function and just using Auto for formatting. Trying to use the num function has limited results. Have you run into this issue? Any ideas on how to fix?
Figured it out. Had to remove % and $ from any column name, then turn on "Decimals Displayed" and then use the num function for every cell. Lots of work, but it appears to be working with these changes.
Hi Lee, this is a great extension, quick question, can you change the color of the fonts, like if there is a positive, can we make this green, and if it is a negative make it into red?
Hi there. Thanks for the suggestion. I am looking into this and created a an issue in Github here: github.com/leematthewshome/Qlik-Sense-Transposed-Table-Extension/issues/9
I have now added this capability. Please refer to the issue link for more info. Note that you will need to download the latest code and update Qlik Sense.
thanks for this Lee, is it possible to just allow individual cell to be colored, as I can set my own expression in it (so I can get individual lines colored)? also is there a way for the table to be more interactive, in the case I click on a dimension and then I can have a specific action for that (example got to next sheet)
could I get your email on this, so I can contactly directly, its very helpful tool, I just need your help to get more features for formatting, such as adding fonts and font sizes, and if we can add text in the value blocks if possible
@@sho1481 I tried this, but the expression seemed to not evaluate at the row level, but instead at the total level. So it could not color individual cells.
Hi Lee! I have just found this video and love the extension. Tried it but it comes with a few questions though... how do you move up and down the measures. Do we have to delete some if we noticed we missed one right in the middle? Also, not talking about comparative columns but is there a way to download the app you are showing on your vid? Can we have some chat by Skype for easier purposes? Great stuff anyway, just fitting my needs!!
@@leemelbourne3297 Hi Lee, thanks for your prompt reply. However, the up and down drag do not appear to be working in the measure section. What I have is a delete cross on the right of each measure. Any idea?
@@Glotiss1 Are you in the chart measure config? That is where you should be, rather than in the master library. Also, what version of Qlik are you using?
@@leemelbourne3297 Yes I do adjust in chart measure config (the column on the right). I am using 2 different support which Feb 2019 Desktop, and Nov 2018 server. It is a real shame as the tool is very powerful... Have you also planned to upgrade it as well? Where can I find some more tutorials, examples of this tool? Thx Lee
@@Glotiss1 Hi Arnaud. I just tested on Qlik Sense Desktop Feb 2019. I am able to drag one measure above another in the chart config by just click and drag with a mouse.
At the moment it is not possible to install extensions into Qlik Sense cloud. If you just want a single user environment, you can download and install Qlik Sense Desktop and apply and test the extension there. You would need to look at Qlik Sense Enterprise for the capability to apply extensions and deliver apps to multiple users.
QlikView extensions use a different architecture, so the Transposed Table extension itself will not work with QlikView. However I have seen people achieve similar layouts with the standard QlikView table object, but via lots of formatting and data modelling tricks.
Hi if i connect qlik sense to data source from SAP B1 Server. I add field (Journal Entry) and (Chart of Account ), how to make the measure expression to have the ledger balance for each period eg Jan, feb.... for each account code?
@@trialbyfire7112 The video was not intended to be an advertisement for just the transposed table extension. It highlights multiple approaches and contrasts them, including using the standard pivot table object in Qlik Sense. Sorry it was not clear that extensions are not supported, however it does point out that the extensions shown are downloaded from our "Open Source" community for free ("Open Source" means not Qlik software). Granted the line has blurred lately, as some extensions now are bundled and supported by Qlik. However there are still hundreds of extensions on our open source platform that are not supported by Qlik, including the two extensions shown in the video.
Hello, since the video is already a few years old, I wanted to ask if this function is now also available for the Qlik Cloud?
Could you maybe provide the data model? That way, we can see how you structured the data in first place
Very useful... How can I get it without the security risk? (in a sense of malicious code in extensions)
Great overview Lee. Thanks for sharing
Gr8 vid Lee,Advise how you created the PL headers for pivot table to group the accounts
Hi. That is all about how you structure the data model, it is just hierarchical dimension values. I think I loaded a sample application on Github with the extension. By the way, I no longer work for qlik, and at the moment do nothave time to maintain this extension. But, like any extension it is just web code and you can get anyone to enhance it if needed.
Can we able to show the measure and dimension in column wise?
Can we able to add multiple dimensions ?
Love the extension Lee. Is there any way to have one column formatted with a $ sign? I want a column for quantity and another for value, with only the value column being formatted with the dollar sign.
Yes, this is possible. I have done this in some apps i have built to use percentage formatting in one column. For the dimension you will need some field with a list of possible values like "Actual", "Budget", "Variance", "Variance %". Then in each measure you need to have an if() statement that checks for the existence of % in the value and use a different format expression with the num() function. Of course in your case you will use $ rather than % to trigger the different format.
I got that working, thanks a lot. A new issue has come up and it may be from the September release. Now the columns with a % symbol no longer show as a percent and columns with a $ symbol show a $ symbol, but after the number. This is with reports that are not using the num function and just using Auto for formatting. Trying to use the num function has limited results. Have you run into this issue? Any ideas on how to fix?
Figured it out. Had to remove % and $ from any column name, then turn on "Decimals Displayed" and then use the num function for every cell. Lots of work, but it appears to be working with these changes.
Nice video .can i get the back end data for this app
Is it possible to export dashboard containing this table to .pdf or .pptx?
Every time I try I get a blank field where the table should be.
It is possible that printing is not enasbled for the extension. I will have to look into that. Please log an issue in Github for tracking
Hi Lee, this is a great extension, quick question, can you change the color of the fonts, like if there is a positive, can we make this green, and if it is a negative make it into red?
Hi there. Thanks for the suggestion. I am looking into this and created a an issue in Github here: github.com/leematthewshome/Qlik-Sense-Transposed-Table-Extension/issues/9
I have now added this capability. Please refer to the issue link for more info. Note that you will need to download the latest code and update Qlik Sense.
thanks for this Lee, is it possible to just allow individual cell to be colored, as I can set my own expression in it (so I can get individual lines colored)? also is there a way for the table to be more interactive, in the case I click on a dimension and then I can have a specific action for that (example got to next sheet)
could I get your email on this, so I can contactly directly, its very helpful tool, I just need your help to get more features for formatting, such as adding fonts and font sizes, and if we can add text in the value blocks if possible
@@sho1481 I tried this, but the expression seemed to not evaluate at the row level, but instead at the total level. So it could not color individual cells.
Hi Lee! I have just found this video and love the extension. Tried it but it comes with a few questions though... how do you move up and down the measures. Do we have to delete some if we noticed we missed one right in the middle? Also, not talking about comparative columns but is there a way to download the app you are showing on your vid? Can we have some chat by Skype for easier purposes? Great stuff anyway, just fitting my needs!!
You should be able to reorder by dragging them up and down the list in the measures config, just like any other Qlik Sense object.
@@leemelbourne3297 Hi Lee, thanks for your prompt reply. However, the up and down drag do not appear to be working in the measure section. What I have is a delete cross on the right of each measure. Any idea?
@@Glotiss1 Are you in the chart measure config? That is where you should be, rather than in the master library. Also, what version of Qlik are you using?
@@leemelbourne3297 Yes I do adjust in chart measure config (the column on the right). I am using 2 different support which Feb 2019 Desktop, and Nov 2018 server. It is a real shame as the tool is very powerful... Have you also planned to upgrade it as well? Where can I find some more tutorials, examples of this tool? Thx Lee
@@Glotiss1 Hi Arnaud. I just tested on Qlik Sense Desktop Feb 2019. I am able to drag one measure above another in the chart config by just click and drag with a mouse.
Where can I get the data source for producing the dashboard in this video for practice? Thanks!
github.com/leematthewshome/Qlik-Sense-Transposed-Table-Extension
@@leemelbourne3297 hi there! I am still missing how to create sub-totals in the data model. Hope you can provide the source xls file. Many thanks
Ps: I am referring to the data model for the simple pivot table
@@giovannicara219 This is no longer possible. I removed the function as it was prone to errors caused by differing data types being returned.
This add-on does not install Qlik Sense Cloud. I want a JSON file extension. Can you help me?
At the moment it is not possible to install extensions into Qlik Sense cloud. If you just want a single user environment, you can download and install Qlik Sense Desktop and apply and test the extension there. You would need to look at Qlik Sense Enterprise for the capability to apply extensions and deliver apps to multiple users.
As Qlik Sense Cloud is a shared platform, there is currently no capability to use open source extensions like this extension.
Hi,
Can you please provide sample data set
great overview. thanks
Hi, Do i need to have SQL or VBA knowledge in order to Master in Qlik Sense?
No. You do not need any coding skills at all to build an app. There are many videos online that show you how to build a Qlik Sense app scratch.
I created my own series of tutorials here: th-cam.com/video/Rk1ZrQGlB3E/w-d-xo.html
Lee, Will these same options work in QlikView?
QlikView extensions use a different architecture, so the Transposed Table extension itself will not work with QlikView. However I have seen people achieve similar layouts with the standard QlikView table object, but via lots of formatting and data modelling tricks.
Hi if i connect qlik sense to data source from SAP B1 Server. I add field (Journal Entry) and (Chart of Account ), how to make the measure expression to have the ledger balance for each period eg Jan, feb.... for each account code?
Search online for information about Qlik Set Analysis syntax. It is very powerful.
Is this extension supported by Qlik?
There are a range of extensions bundled with Qlik Sense and supported, however at this stage this visualisation is not one of them.
@@leemelbourne3297 Got it thanks. Then why does Qlik market it as a solution to a common issue if it's not something that they support?
@@trialbyfire7112 I have not actually seen Qlik as a company market it as such. But they do support the APIs it is developed on.
@@leemelbourne3297 But this video has a Qlik intro and is titled, "Qlik Sense for Financial Reporting". Is that not marketing it as such?
@@trialbyfire7112 The video was not intended to be an advertisement for just the transposed table extension. It highlights multiple approaches and contrasts them, including using the standard pivot table object in Qlik Sense. Sorry it was not clear that extensions are not supported, however it does point out that the extensions shown are downloaded from our "Open Source" community for free ("Open Source" means not Qlik software). Granted the line has blurred lately, as some extensions now are bundled and supported by Qlik. However there are still hundreds of extensions on our open source platform that are not supported by Qlik, including the two extensions shown in the video.