to follow, share, and participate in this community.
Hi All, I have a field that contains random text and I want to split the text into single words. The text can be separated by spaces, commas, periods, etc. I tried using SubField with a space separator but I... Hi all, I got a problem while excluding NULL-Values: In the area plot I want to show regions when there are values. The problem is when I pick my dimension and give it a sum()-formula into the color formula i... Hello, Is it possible to have in a line chart multiple expressions , one dimension in one line. Expressions are ( sales N-3 ,sales N-2, sales N-1, budget N, sales N), dimension Year please see the screenshot... Hi, I have a simple table as below: Salesman Product Cost Month Richard Bus 500 JAN Johan Car 200 JAN Johan Bus 700 JAN Leroy Boat 800 JAN Leroy Plane 15000 FEB Samuel Car 300 FEB Richard Car 2000 MAR Samu... Dear all, I have no idea how the aggr and median function works in QlikView. I have the data below. FACT_PA_NO Fiscal Year Division TotalCash FiscalNumYear FiscalMonth 7141 FY13/14 Motors 709.5 2013 1 7141 FY1... I need help solving a situation. Let's suppose I have a table with up to 3 records for each salesperson. The date will have a Sales Date, Sales Person, and Sales Amount. I need a formula to calculate the average sales... I have a very large set of data on assets i.e. Servers With corresponding information on the servers - host name, ip address, cores, operating system, vendor, model etc... I would li... Please find attached data I have Table1 like this and need to arrange like Table 2.Can somebody let me know what is the workaround i.e using in set analysis to get output like Table 2 Table 1 : Row Labe... Hi all, I have an item list per department along the different ordered quantities and price per item over different periods. I need to compute the inflation rate between two periods. The formula : Qty_... Hello All, I am trying to achieve the below orientation for my pivot table. Could you please help me with a work around? I have pivoted 3 dims, month, week and date. I need to show data alone in ver... I've created a pivot table that shows department, month, and year dimensions and has three expressions for the totals columns. I want the chart to only show 3 months of data, with this always being the most recent thr... I have a bar chart with a specific reference line. The reference line represents a target or a goal of 10%. However, when the bar chart values go below 10%, I lose the reference line. How can I make ... Hi, i have those data set as shown below. I would like to give to the users the possibility to select just with a click the "Cliente" where the "Importo Promessa di Pagamento" has an amount (so is different f... Hola, soy nuevo por aquí, me presento, mi nombre es Viktor Glez y soy novato en Qlikview, espero ser colaborador del sitio, así como en este caso un poco de ayuda, al Asunto: Tengo una duda acerc... Hi, everyone. Is it possible to display the Series line in the stacked bar chart like excel? Hello! I work for an oil and gas company and recently had a request to create a 3D wellbore visualization in QlikView similar to the image below. Has anyone been able to accomplish something like this? Any adv... Hi all, i need to show percentage in a bar chat like the screenshot below, can anyone tell how to do it. the percentage represents the evolution between the bars . For exemple the sales evolution from 2012 to 2011. o... Hi All, I got this popup message when I try to open QV document
This QlikView document was created by another QlikView Personal Edition user or on another computer.
As a QlikView Personal Edition user, you m... ※ 以前以下のとおり投稿させていただきましたが、回答を得られなかったため改めて投稿させていただきます。 https://community.qlik.com/thread/280542?sr=inbox ストレートテーブルの罫線に関するご質問です。 同一グループ間の罫線を消したい（もしくは白色にしたい）のですが、その方法についてご教授いただきたく、投稿させていただきました。 例えば、以下のような... Hi, I have a bar chart with 4 expressions and no dimensions. It shows a bar for each one. My expressions are: Reg1, Reg2, Reg3, Reg 4. I know that i can reference these values in another expression by the f...