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

I have an xlsx where there is data from column A till column AR.

In the future there can be data till column BE.

So I will load all columns till AE in Qlikview.

If I do 'Data from data files' and select my xlsx and the correct tab then I see only till column AW.

If I put values in columns AX till BE I see the columns for adding in the script.

Bur if those are empty it's only till AW. How can I load the columns AX till BE even if there is no data in.

Who knows how I can load the empty columns?

HI an amazing Qlik community 👋

For those who have migrated apps to Qlik Cloud - have you come across any major app design offenders that caused a dramatic increase in App Base RAM size (above 5 GB limit)?

We’re seeing an app with a ~0.2 GB file size consuming ~12GB of Base RAM.
Has anyone experienced something similar?

Which visualisations, design choices, data models etc did you find that significantly increased app base RAM ?

Any insights, lessons learned, or best practices would be greatly appreciated 🙏

Qlik Cloud 

Hi!

As part of our ongoing commitment to provide the best possible experience for Qlik Cloud users, we are removing the Basic and Full User construct from tenants on capacity-based subscriptions, simplifying to just User.

Read all the details here!

Hi!

As part of our ongoing commitment to provide the best possible experience for Qlik Cloud users, we are removing the Basic and Full User construct from tenants on capacity-based subscriptions, simplifying to just User.

Read all the details here!

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 all,

I know the standard qliksense pivot table able to drag or reorder the dimension position. However, pivot table in visualization bundle have limitation on this. 

Is there any way or alternative as my user want the capability to drag the dimension.

Regards,

FT

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, In Qlik Automation I’m calling a PostgreSQL procedure using the Postgre>Do Query block:

I simply put into 'Query *' field:
call schema.procedure_name();

The block usually keeps running for a 2 hours 5 minutes or eventually times out, even though in PostgreSQL the procedure is triggered immediately and finishes in less than a millisecond (based on my logs).

Do you have any experience or recommended block/workaround for this?

Thanks!