We are migrating from QlikView to Qlik Sense in SaaS. I would like to set similar triggers for  specific dimensions when the report first opens. How do I do this?  

Hi,

I'm moving to Qlik SaaS from Qlik sense on-prem and I would like to know if there is something like the NewStand (from Nprinting) for Qlik SaaS.

Is there a way that users can preview or download the reports that they have access to ? 

If not, what would be you alternatives ?

Thanks ! 

Hi everyone,
I have a database which is connected to Qlik Sense. There is a record in the database which is not loaded in Qlik Sense. There is a QVD Generator between database and Qlik Sense. The problem exists only for one record and other records are loaded without any problem. Has somebody any idea to solve this issue?

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?