As the title says - Qlik community is so inactive its hard to reach for help to debug something or atleast get an understanding what could possibly went wrong. Its not a rant but I guess people proficient in Qlik should take more care of helping newbies, otherwise PBI would always be go-to BI tool. What do you think?

Dear All, 

I am using qliksnese now i want to open qliksnese hub by using public IP but my 443 port is already using by another application.so how we can assign different port to QPS(HTTPS) in qliksnese.

I'm new to an organization that migrated from Qlik View to Qlik Cloud. While I have a intermediate grasp of SQL some of the scripting and expressions in Qlik Cloud are hurting my brain. To make matters a more challenging I'm trying to learn based on a previous data developers code. It's all hieroglyphics at this point. If anyone could point me to an online course, a content creator, a book, anything with more information I would appreciate it.

Hi All,

I am calling a variable in a Straight table and in a Pivot Table. Pls refer below expression,

if(match( Avg(Aggr(Sum({$<Year=, Month=, Day=,
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Value),Code, Id), -1, -2) and Rank(total Num(Avg(Aggr(Sum({$<Year=, Month=, Day=,
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Value),Code, Id),'#,##0%')<=10, 2, Avg(Aggr(Sum({$<Year=, Month=, Day=,
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Value),Code, Id))

This variable converts the value from 0 and 1 to 2... for the top 10 records for the condition. I have noticed below conditions:

1. It is not saving and still the value is showing as 0 and 1 instead of 2. 

2. If i add '=' in front of the expression, it is showing as -2 for all the values instead of 2. 

Pls note, i am using Qlik Sense Desktop. November 2024 version.

Thanks in advance.

 Hi,

I want to sum inventory based on the minimum and maximum dates within each Year-Month combination, I need to conditionally sum the inventory for only the rows corresponding to the minimum and maximum dates.

the final result must be like the attachment.

can anyone helps me how to write the expressions?

Please help me in solving this issue.

Hello Team,

I am trying to fix the below set analysis expression "-=" operator not working.

In expression, I want to filter data related to Due amount as highlighted below 

Num(

  Sum({<

    Cleared_Flag={'Unpaid'},

     [%KeyDate]={"$(=max([%KeyDate]))"},

     IsDebitor={"$(vDebitorsOnly)"},

     [Ev_Overdue.Type]={'Overdue'},

     [Ev_Overdue.Bucket]-={'Due'}

    >}

  [Account_Receivable_Evolution.Amount_$(vCurrency)]

  ),

  '# ##0' & '$(vCurrencySymbol)'

)

This works earlier suddenly stopped working kindly help on this issue.

Hi everyone,

I'm relatively new to Qlik Sense and currently building dashboards for my organization. I’ve noticed that the layout of my dashboards changes depending on the screen resolution of the monitor being used to view them.

Specifically, I’m using several KPIs within a Container object, and on lower-resolution screens, the layout appears to shift or break in unexpected ways. In some cases, objects that were neatly aligned on one screen appear stacked or misaligned on another.

My current fix is by using the browser zoom out function. But I’m wondering:

• Is this expected behavior due to Qlik Sense’s responsive design?

• Does using multiple KPIs inside a container cause layout issues across different resolutions?

• Is there a recommended best practice to ensure more consistent layouts across various screen sizes?

• Any tips on how to structure containers or grid layouts to be more resolution-independent?

I’d really appreciate any insights, recommendations, or examples from your experience. Thanks in advance!