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

Hello,

I have just installed QlikSense Enterprise November 2025 and when I try to export a graph, table or page to PDF, I get a blank PDF.
Is there a patch or method to fix this?

Thank you in advance.

Romain

I have around 12 measure and 10 dimension in my table and above that table I have filters. these 12 measures are divided like 7 and 5 so there will be 4 filters.

Filter1 -  suppose I have give 7 measure in my table and named as measure1 to measure 7 so I will have filter that would have these measure list from 1 to 7

Filter2 - have bucket of values that I have in my table like >5 Lakhs, 5-10 Lakh and till 25 Lakhs

Filter3 - have rest of the 5 measure and have name as Measure8 to measure12 names list

Filter4 - have again bucket from >5 Lakhs , 5-25 Lakhs and so on till >2 Crores

Now based on the selections my tables measure should reflect , like user select Filter 1 -measure 5 and Filter 2  5-10 Lakh then in my table all values should come between 5-10 Lakh only and same for 3rd and 4th filter whatever measure selected table measure should reflect according to that. FYI- All measure are different not same in filter 3 there will be another measure that should also reflect accordingly

Hi all,

my post is not really a question but more a notification about a bug in the Management Console.

While creating a new Trigger in the MC I noticed that the date and day of weekin the dropdown calendar do not match by one day. Once the Trigger has been defined, the date / day of week match on the summary page.

See the attached screenshots for more details.

I'm fairly new to this system, so I don't know if this is the right place to inform about the bug. 

Hi Qlik Community

Is there a way to allign the segements of a stacked bar chart with the legend? See picture below for clarification.

If have found a way to flip the order but that flips both the segments and the legend, so they will still not align. Any help is appreciated.

Casper

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.