Boa tarde,

No Qlik Sense, como posso fazer para que, ao abrir o aplicativo, já seja selecionado automaticamente o mês e ano atual, sem ser necessário selecionar manualmente nos filtros respectivos?

Obrigado

Hola a todos!

Requiero hacer una nueva columna con la siguiente formula:
"Utilidad Unitaria" = "Utilidad Operación" / "Volumen 3"

Los datos están dentro de una tabla pivotante.

De antemano les agradezco el aporte.

Hi Everybody,

I am trying to implement a hierarchical drop down menu in the mashup using enigma js. To get the data I am using a session object of type 'tree' and 'getHyperCubeTreeData' method. 

The whole tree is quite large so I decided to extract it one level at a time (qDepth = 1) based on user's clicks (without selection). E.g. I only extract the children of the node that the user clicked.  

The problem I have is I can't quite get how do I specify the qArea to extract only a specific node's children. I was trying to get qArea limits from a selected parent but apparently something is wrong there, the function returns random (as it seems) parts of the cube, the whole field or an empty array. 

Could you please help me to specify the qArea parameter to get a specific node's children?

const hierarchyObject= {
    qInfo: {"qType": "tree-list"},
    qTreeDataDef: {
        qDimensions: [
            { qDef: {  qFieldDefs: ['=[Field1]'], qNullSuppression : true} },
            { qDef: {  qFieldDefs: ['=[Field2]'], qNullSuppression : true} },
            { qDef: {  qFieldDefs: ['=[Field3]'], qNullSuppression : true} },
            { qDef: {  qFieldDefs: ['=[Field4]'], qNullSuppression : true} },
            { qDef: {  qFieldDefs: ['=[Field5]'], qNullSuppression : true} },
            { qDef: {  qFieldDefs: ['=[Field6]'], qNullSuppression : true} },
            { qDef: {  qFieldDefs: ['=[Field7]'], qNullSuppression : true} },
        ],
        qInitialDataFetch: [{
            //qMaxNbrOfNodes: 100,
            qTreeLevels: { qDepth: 1, qLeft: 0},
            qTreeNodes: [{qArea: {qLeft: 1, qTop: 0, qWidth: 100, qHeight: 100}, }]
        }],
        qMode: 'DATA_MODE_TREE',
        qOpenFullyExpanded: true,
        qSuppressMissing: true,
        qAlwaysFullyExpanded:true
    }
}

async function drillDown(node) {
        console.log(node)
        let leftOffset  = node.qTreePath.length+1;
        let topOffset   = node.qGroupPos; 
        let batchHeight = node.qGroupSize  ;

        console.log(leftOffset, topOffset, batchHeight)
        let obj = await hierarchyObject;

        let treeData = await obj.getHyperCubeTreeData({
              qPath: `/qTreeDataDef`,
              qNodeOptions: {
                qMaxNbrOfNodes: 100000,
                qTreeLevels: { qDepth: 1, qLeft:  leftOffset},
                qTreeNodes: [ {qArea: {qLeft: 1, qTop: topOffset, qHeight: 1, qWidth: 1}}],
              },
            });

        console.log(treeData)
        
    }

Hello everybody,

I would like to write an expression that counts customers who placed orders worth more than 150 in a certain time frame.

I wrote this expression but it is wrong because the symbol " is repeated several times:

Sum({$< customer_id={"=Sum({$<OrderDate={">=$(=Date(vStartDate))<=$(=Date(vEndDate))"}>} Amount)>150"} >} oneCustomer)

What is the correct syntax to get the desired result?

Thanks in advance

Hi Everyone,

My data is like this

I want to display the pivot table in a way that the Rows are not duplicated for the locations with '-' in them. Currently it looks like this:

But I want that the + sign should not appear before the 19 Div 1 here as the location4 and location5 are '-' for it. I have tried using if condition and also the "Show column if" but they are not working. Any help is appreciated.

Regards.

Hi - I have what I think should be a relatively simple task to write a chart expression for, but have been unable to find a solution from searches. Hoping somebody can help.

I have a table with two columns /Fields - Baseline and Release_Date

Baseline                           Release_Date

2022 Dec BOD 4             20/11/2022

2022 Dec BOD 5             18/1/2023

I already have a Variable that returns the latest date, 18/1/2023, from the Release_Date Field - vLatest_Release_Date = Date(Max([Release_Date])) - and I need an expression that returns the '2022 Dec BOD 5' by 'looking up' the Variable in the Baseline Field

The Baseline Field format can have many different formats - the expression just needs to return what's there based on the Release Date.

Many thanks, Richard

I'm freelancing a little until the end of my education. I found a company that would hire me for a few days per month. Here is what will expect me:

They have a few different systems. All backed by some kind of RDMS. And there is a QlikView installation. Nothing more. QlikView is not configured to do anything, it's just installed on a dedicated server.

Tney need a few reports, by aggregating data from different sources. They also want something like a daily export of the data.

I have no QlikView experience, but would like to tackle the job. Are there any resources online to educate myself?

Hi All,

Greetings!!

I have created a windows task using the service account and scheduled it on daily basis around 09:00 AM.

below the batch file used:

"D:\Program Files\QlikView\qv.exe" /l "\\naspqvlrd\QVSource\portfolio\Loading\financial.qvw"

Issue: job did not start and status is showing in ready state only. While manually running the task its showing running but no result. Task history shows that Task scheduler completed successfully.

Need more understanding of the below batch file:

"D:\Program Files\QlikView\qv.exe" /l "\\naspqvlrd\QVSource\portfolio\Loading\financial.qvw"

 As per my understanding, it will open the qv.exe file(that is empty Qlikview file) first and opens the QVW file(financial.qvw) in that empty QV file which is provided in shared path.

D:\Program Files\QlikView\qv.exe"

Observations: I could see Qlikview software is installed/placed in the C:\Program Files\QlikView\qv.exe but not in the "D drive"(like above batch file path)

is it the problem that unable to find the location of the QV file in C drive to run the job?

appreciate your help!

Regards,

RickyK