Our Server's User CALs are all occupied. When I tried to release some of them I found that the QMC> System > Licenses > QlikView Server > Client Access Licenses (CALs) > Assign CALs tab returns nothing. It didn't show the User Names as it appears in our other lower QV environments. any suggestions. thanks in advancee.

Hi all, 

I am very new to Qlik and still learning Qlik expressions and Set Analysis. I am stuck on a seemingly a very simple task and it appears that ChatGPT has also given up and I cannot find any answers anywhere that can help me with this issue. 

So my requirements are pretty simple: A Straight table with the following columns: 

Column 1:   [MMM YYYY]  = Date formatted as [MMM YYYY]

Column 2:   [Sales]             = Sales for each [MMM YYYY] for the select period 

Column 3:   [Sale LY]          = Sales from the Previous Year, Same month as [MMM YYYY]

In Power BI it will take me less than 2 minutes to do this, by just simply using SAMEPERIODLASTYEAR() function. But Qlik is having none of it and I have tried almost 50 different solutions trying to achieve this. 

So I have a FactSales table and a MasterDateCalendar table. 

My Sales Expression looks pretty simple: 

=Sum([SalesAmount])

For Sales LY I have tried a number of things: 

=Sum(
  {$<
    [SalesDate] =,
    Month =,
    Year =,
    MMYYYY =,
    MMMYear =,
    YYYYMM =,
    YYYYMM = {"=$(=Only(YYYYMM)-100)"}>}
  [SalesAmount]
)

Another thing I have tried: 

=Sum(
  {$<
    [SalesDate] =,
    Month =,
    Year =,
    MMYYYY =,
    MMMYear =,
    YYYYMM =,
     [SalesDate] = {">=$(=Num(AddYears(Only([FirstDateofMonth]), -1)))<=$(=Num(AddYears(Only([LastDateofMonth]),  -1)))"}>}
  [SalesAmount]
)

[FirstDateofMonth] and [LastDateofMonth] are columns from my MasterDateCalendar table. 

All of the above show Zeros for Sales LY. 

I am absolutely gobsmacked by the fact that such a simple thing in a BI tool could be this difficult to achieve. 

Ideally, I would want a straight table with output as shown in the attached image. 

Any help or pointers in the right direction will be much appreciated. 

Thanks in advance. 

We have to match two lists that only have Company names, and no common IDs or any other field to JOIN them on. To use fuzzy logic to match Company name fields to join the table in Load Statment. Please refer to the file and screenshot.

Bonjour,

J'ai un tableau Qlik contenant des valeurs numériques.

Lorsque je le télécharge au format de données "Excel", les nombres apparaissent en millions d'euros.

Comment faire pour que le format d'affichage Qlik soit le même dans l'extraction excel ?

En vous remerciant par avance pour vos pistes.

Céline

Hello everyone,
I have watched some presentation videos about the new Write Tables and I would like to clarify a few points.

From what I understand, Write Tables allow updates only on one or more columns associated with an existing record based on a defined key, but they do not allow inserting new records. Is that correct?

For example, if I want to manage a forecast by country, I could define the country as the key and have an editable column with the forecast amount. In this case, if I need to add a new country, is it possible to do it directly in the Write Table, or must the country already exist in the underlying dataset?

Another point that is not completely clear to me is the 90-day retention of the changes. What exactly happens after 90 days?

Continuing with the forecast example, if this table is used to display the forecast throughout the year, would the editable values for rows that have not been modified for 90 days be removed?

I understand that modified data can be extracted before they are deleted, but in a management table like this I cannot clearly see the practical usage. For example, I cannot write the edited value into another non-editable column within the same table.

Thanks in advance for any clarification.

Hi,

I'm experiencing a strange problem on some of my computers (but not on all of them...)

- In the layout, no icons appear when I hover over charts

- In expression editor, there is no Intellisense prompt when I type functions and fields

- in script editor, there is no prompt either, and the Tab key doesn't cause tabulation, but instead moves focus out of the script.

Does anyone know what it might be caused by, and how to restore the "normal" behavior? mto‌ any chance you've seen this one?

Appreciate your input,

Oleg Troyansky

I have this table with Name and Color

ColorData:

I want to get all the distinct sorted combinations of each name. Joined by a pipe | symbol.

ColorDataCombos:

Note: if it is not possible to get sorted and distinct ones that’s fine. I’ll take all permutations for each name even though there may be many

(Connector error: closing data chunk stream from client) from File Access Gateway

What seems to be causing this error and how can we resolve it?

Attached here are the logs and content of the json file stated in the connectoragent logs

Qlik Data Gateway