Hi. i have inphinity forms table called "SKILLS".

I takes from this all column names with listboxes loop (working well).

I need to do visualization (table). Where first column will show "COLUMN_NAME" from listboxes

and second column will be calculated AVG value from table "SKILLS" (source for listboxes).

Measure should find column in "SKILLS" table according COLUMN_NAME from list boxes.

Next step will be add employee and department according to "ID" column in table "SKILLS".

Idk if this approach is the best solution maybe crosstable is better but I am wondering if such calculation is possible.

Below my data model:

Thanks in advance.

(Apologies, this was posted earlier but was my post was so full of flaws, I removed it).

I am trying to show a graph of tickets raised over a periiod of time.  In my data I have zero 'Open' tickets in October and as a result October does not show on my graph.

I have tried a 'Master Calendar' which works until a filter is applied.  -

I have also read about adding + sum({1}0) to my measure.

Count({<[Status]={'Open'}>}id) + sum({1}0)

and setting the Addons -> Data Handling -> Include zero values 

Any help would be appreciated

Hi,sales

I have ranked my stores by sum(sales) by the expression: rank(sum(sales).

I want to create a KPI that will indicate my rank store based on the name store.
for example:

If my store las Vages is ranked as 13. I want my KPI to show 13 at any time I choose this specific store.
if I just put this expression rank(sum(sales) I will always get 1 because I am filtered in this specific store..

how do I get 13 for example for the choose store? 

Hi all,

We are planning to upgrade to qlik sense enterprise edition of November 2023 ,can anyone please confirm whether this upgrade will works fine on postgres version of 12.5 or upgrade to the 14.8 is required?

Regards,

Raju