I have an excel sheet which i'm trying to take  P&L Setup and B/S setup. I can bring the all accounts with interval match but I could not bring the "sub total" lines according to between RowFrom and RowTo columns. I'm adding my Excel file.

I'm using in my expression but it does not help, can some one send me a sample?

if(RowType = 'Regular',Sum({<[Fiscal Year]={$(vYTDYear)} >} Amount),
if(RowType = 'Sum',aggr(Sum({<[Fiscal Year]={$(vYTDYear)}, RowNo= {"<=RowTo"}>}Amount), ReportRowGroup)
))

Regular part is coming but Sum parts are not coming? Please advise

Hi Team,

I have a below table.

Further I want to add new column as below. Kindly help me in doing this.

Hi All ,

I am using just a simple script to load the hierarchy , but i am geting 1 bank roe at each level . please tell why ?

A:

Hierarchy(X,Parent,Des)

LOAD Des,

     ID   AS X,

     Parent

FROM

(ooxml, embedded labels, table is Sheet1);

We are currently experiencing some performance issues in our Qlik Sense site and have been monitoring app reloads from the reload monitor app. However it only appears to show apps reloaded on a schedule or manually from the QMC.

We are concerned that a large number of Hub reloads could be causing performance degradation and so would like to see information in relation to this i.e. how many have been triggered and from which apps, but we can't find anything. Where can this information be found?

Hello QLIK Community,

at the moment I am despairing of the following topic and I hope someone can assist me here. What is it about:

It should be possible to aggregate the costs of each individual BOM level so that the total costs (material costs, production costs) for the product are visible at the end. The used ERP ist Microsoft Navision 2009.

I know that the "Hierarchy" syntax should work but i don´t have any clue, how to use it correct. At the moment I use the following script similar to that topic: https://community.qlik.com/t5/QlikView-Scripting/Bill-of-Materials-from-Navision/td-p/414790

Fakten_BOM:

Hierarchy ( Article_Nr., BOM_Nr., Node_Name, BOM_Name,Child, Pathfield,'|',Level)
Load

Article_Nr.,

Article_Nr. as [Node_Name],

BOM_Nr.,

BOM_Nr. as BOM_Name,

Description

Version

Art,

Amount

FROM
[XYZ.qvd]
(qvd);

The result is not as desired, because within my Table-Box I only see results until Level 2. But there are at least 8 Levels within BOM´s.

Does anyone have an experience in aggregating the costs of each individual BOM level in connection with MS Navision? If so can you give me a hint how to solve the problem? 

Many thanks in advance

Greetings

Manuel

I have a Nprinting 16.9 report in which I'm applying filters on owners and sending them mails. 

However, the xls attachment needs to be formatted before I send. I have created a macro to do so.

Is it possible that with one report task, I create the files and store in a location.

The next report will pick the files from the location and trigger the mails. 

Please help!

Hi All

Please find below my problem. My Table only contains these 4 fields and a variable called vPreviousPeriod that is equal to 201910 at the moment.

I've created 2 textboxes so you can see what I am trying to do. The top one, shows the expression I'm using. The bottom one, the result.

I want to get the FINYR_CALL for the max(CALLMONTH) but its not working.

Please may you assist with my expression?

Thanks

Guys, now I have my qlikview application finalized and I would like to leave it in a browser, how can I do that? Local Only.

(I would like to see it working in a browser)

Text obj with images as expression (with relative path, e.g., ='..\data\img\imagefil.png') are not working properly. When the path is correct, the object is blank (its configured without a background). If invalid path, it works showing the invalid path.

This behavior started after upgrade to april 2019 version (12.40.20200.0)