Welcome to Qlik Community

Quero carregar vários arquivos que possuem mais de 50 MB cada um no Qlik Sense Web da empresa onde trabalho. Quando tento executar o carregamento recebo mensagem de que "O tamanho do meuArquivo.txt excede o limite do tamanho de arquivo. Tamanho limite: 50 MB".

Como posso carregar arquivos com mais de 50 MB?

Hi guys,

I created a bar chart based on numerous conditions and it shows me correct me values but not on sorted. 

I tried to sort by expression in sorting option however it is not available for me.

Is there any other way that I can sort ?

Hi all

I was wondering if it's possible to genereate the filter values during runtime, based on the selection of a user.

The scenario includes at hierarchical filter - and I would like to hide the SUB-values, until the main group is selected. simplified like this:

Filter:

A
- AA
-- AAA
B
- BB
-- BBB
C
D

The Initial filter should then show A, B, C, D and pressing A would reveal -AA in the list.

Was looking into variables evaluating wether or not a value is selected, returning -1 or 0.  Next step would be to filter the list, or maybe generate the list of values in a variable? But didn't succeed in passing a variable as input to a filter 🙂

Maybe it's not even possible, as the filter needs to reevaluate at every selection

Thanks in advance.

Hello,

Is it possible to export a list of the triggers applied to an existing document (including tab-, field-, and variable-based triggers)?

Thank you,

Ellen

Hello Qlikers,

I want to Calculate the Sum Field By ID as per the below example, How that you can help with this. Thank you!

Are there any known limitations or bugs for intervalmatch()?

I am trying to match about 3.200.000 intervals with 26.280 timestamps (3 years, 24 hour / day).

During reload the script makes progress for the first 10 minutes and then gets stuck around 492 million rows, which is roughly around 50% of the estimated result. After that it doesn't do anything for 3+ hours (at which moment we killed the reload). The QVD it should store never shows up. It also does a short "freeze" around 210 million rows (for around 15 seconds), but the customer says "the server does that sometimes during reloads".

Currently running June 2020 SP1. Server has 128GB RAM (but doesn't even get close to 50% usage).

Any ideas / known issues / limitations / bugs?

Hi, 

I need to create a 'Target' line within my line chart based on the 'Month_TY' , but not quite sure how to do it. 

The X axis ('Month_TY') shows 0 - 12. What  I would like to see on my line chart is the following values if possible please? Example: month 0, the target of new sales is 2, so if my actual sales are 5, I can clearly see we have beaten the target put in place. 

if 'Month_TY' = 0 then 2

if 'Month_TY' = 1 then 8

if 'Month_TY' = 2 then 15

if 'Month_TY' = 3 then 20

if 'Month_TY' = 4 then 28

if 'Month_TY' = 5 then 34

if 'Month_TY' = 6 then 42

if 'Month_TY' = 7 then 52

if 'Month_TY' = 8 then 59

if 'Month_TY' = 9 then 67

if 'Month_TY' = 10 then 71

if 'Month_TY' = 11 then 75

if 'Month_TY' = 12 then 80

Any idea if this is possible please? 

Hi guys,

When testing the qlik alerting extension from the qlik sense app, it shows me a message saying "authentication failed ......"

I have enabled port 4552 and check https. If I change the port to 4551 and uncheck the check it shows me another error message: "Could not retrieve user info....."

Can anybody help me?

I have tried everything and do not know what else to look at.

Thank you!

Hi All, 

I have a fact table (Date table ) which has 3 date fileds in it , "IssueDate", "DeliverdDate" and "ClosedDate". 

As per the requirement I have created the date table so that missing dates get populated . 

But in the data model i am having loop . Ecery table has to be connected the way it is but the looing should be avoided .

Can anyone please correct this connection. 

Thanks in Advance

Hi All,

I am wondering how I can sort an always one selected field.

In my case I have 1 field which has a date value for each week starting 2017.

Right now when I make this field always one selected, it will show the 2017 dates on top.

However I want the sort order to start with the latest available dates.

I have tried using: 

But without luck.

Anyone that can help me get the latest dates to show first?