Hi all,

I  have a drill down country -> City -> Store in scatter plot . And i am counting the dimension field value in variable in reference line expression For example:  count (drilldown) . I am having challenge in variable, In drill down dimension  if the value is one,  it will automatically drill into next level . So it is  hard to get the exact dimension in variable .

Please help me on this.

Hello I need to get a count of Inventory, description and breakdown of inventory received date so that I can filter items with an aging of more than x months. I can get a count of inventory and description but am at a loss om how to filter according to aging. My fields are InventoryName, Description, InventoryDescription and ReceivedDate. Any suggestions would be appreciated 

Hi Everyone, i want to add forecast data (top left) to our data model but i always get a circular reference which i can not solve. 

How can i associate my forecast data to a date if not like this?

Hello everyone,

I´m developing a Financial Flow using a Dynamic Table because I need to navigate down the structure. But I don´t need the user to change the order of the levels or to search words. So, I Woldn´t like to show the icons of the search glass (above). Can I exclude them? (example attached)

Hello,  I have created a scatter chart.  The size of the bubbles is based on cost.  I have created a slider by percentages to increase or decrease the cost. When I hover over the bubble after I slide the slider to a different percentage I see that the cost changes correctly but the bubble size doesn't.  What am I doing wrong?  If anyone could point me in the right direction.

Thanks!

Hello dear experts,
I have a field called Fecha as a date, i'm trying evaluate it with a rate of dates depending of the value which evaluating Date field, once i  try to load data the next error comes(Attached image).

if(Fecha<Date(30/01/2015,'DD/MM/YYYY'),
if(PM < PE15,1,0),
if(Fecha>= Date(06/01/2016,'DD/MM/YYYY'),
if(PM < PE16,1,0),
if(Fecha<= Date(10/05/2016,'DD/MM/YYYY'),
if(PM < PE161,1,0),
if(Fecha<= Date(17/11/2017,'DD/MM/YYYY'),
if(PM < PE17,1,0),
if(Fecha<= Date(29/04/2019,'DD/MM/YYYY'),
if(PM < PE,1,0)
)
)
)
)
) as Sub_PE

Thanks for help.

Regards.

Hi all,

I have the following script. I need to load a 'Code' and a 'Rate' from a table. From there, I need to associate that code with both 'Group 3' and 'Group 4' Group, and a 'Location A' and 'Location B' Flag. The script below works fine, but I end up loading the same data 4 times. I do this same type of thing repeatedly throughout my script, so I was wondering if there was more efficient way to do this with a loop or variable or something of the sort. Any help would be appreciated. Thanks!

LOAD
'Group 3' as "Group Flag",
text("Code") as Procedure,
'Location A' as "Flag",
Rate
FROM [lib://table.xlsx];
LOAD
'Group 3' as "Group Flag",
text("Code") as Procedure,
'Location B' as "Flag",
Rate
FROM [lib://table.xlsx];

LOAD
'Group 4' as "Group Flag",
text("Code") as Procedure,
'Location A' as "Flag",
Rate
FROM [lib://table.xlsx];
LOAD
'Group 4' as "Group Flag",
text("Code") as Procedure,
'Location B' as "Flag",
Rate
FROM [lib://table.xlsx];

Boa noite.

Ainda iniciante no Qlik, estou com dificuldades no Set Análises.

Preciso selecionar o mês de consulta a partir do dia corrente e gostaria de fazer essa seleção no Set Analysis, mas consegui com IF:

Criei uma variável que indica o mês a ser consultado:

1) vMesConsulta = IF ( DIV((Num(day(today()))),20)=1, num(month(today()))-1,  num(month(today()))-2)

We are experiencing unacceptable long startup times when opening a mashup for the first time. As in the range 5-15 seconds.

To narrow down the scope, we have tried jMeter to test repeatedly downloading the two request taking the most time:

• /resources/assets/external/requirejs/require.js
• Open the websocket 

Most requests (50-60%) take less than 100 ms, both require.js and the websocket. Fine.

25% of the requests are in the interval [100 ms, 1000 ms]. Far from great, but ok.

The rest spread out between 1 to 5 seconds. Per request. Some requests taking as long as 10 seconds to complete.

Below is a sample of a test run today. We run 20 iterations, wait a minute, 20 new iterations, etc. (Always waiting 100 ms between each request.)

Y-axis is time of the request, in seconds.

If we zoom in on four of the runs, you better see the spread.  There is an indication that the first requests are generally slower than at the end of a test run. But this is not always the case (like test run 3 in the image below).

We cannot find any other pattern correlating to any other known events. Apart from that there seem to be a correlation between the time opening the websocket and the time it takes downloading the require.js.

Does anyone have any ideas on how to divide and conquer this problem? 

Do you have any idea how to test if it is: Qlik? NodeJS? The OS? The disk? The VM? The Network?

We are running Qlik Sense and Qlik QAP on Windows 2016 64-bit, 32GB RAM.

It is virtual, but with dedicated memory, disk and CPU.

The test above is removing the mashup and the data model completely from the equation.  It is just looking at opening the connection, and getting a fixed file.

What are your response times? Similar?

Any feedback appreciated!

Cheers,

Vegard 🙂