We have Nov 2018 QlikSense version. I am root admin.

Question:

How do I approve either User created sheet or Community sheet to base app. 

Currently I am not able to see any sheet that user has created. 

I have two tables on the Script:

Telehone_table:

load

Telephone,

Campaing_code,

Campaing_descrip,

Campaing_start_date,

Campaing_end_date

Telephones_records:

Telephone,

Date,

Calls,

Sales

The most obvious will be to do  use Telephone as KEY but  the problem here is that Telephones are reused over time for new campaings, so there is a list of about 50 telephones whereas they are reused for Campaings over time. How to link those tables by a convination of Telephone, Campaing_start_date and Campaing_end_date?

Here is a small sample of each table

Telephone_table:

Telephone,       Campaing_code,      Campaing_descrip,     Campaing_start_date,     Campaing_end_date

1001 (*)                    001                                 Campaing1                      01/01/2019                            15/01/2019

1001                     002                                  Campaing2                      16/01/2019                             23/01/2019

.....                           ......

Note (*): Watch that the same telephone number 1001 is reused for Campaing1 and Campaing2

Telephone_records:

Telephone,           Date,                      Calls,           Sales

1001                       01/01/2019          20                   3

1001                       02/01/2019          25                   6

.....                            .....

Thanks in advance!!!

Hello everyone,

Recently I have moved my client from Qlik Sense Cloud to Qlik Sense Business and it was a great upgrade as Qlik Sense Business has much more features and more user friendly.

The one issue however we are having is export pivot table to excel. When you download Pivot table with multiple rows and columns qlik downloads entire data where all the columns and rows are expanded what makes excel impossible to read or work with.

I am attaching a picture of pivot table in Qlik and the excel file that have been downloaded so you can see the outcome.

Is this a bug that will be fixed soon as my client is very upset with that and I am sure there will be more?

Please help

Excel Download:

Pivot on Qlik

I am new to using qliksense and we just now started trying to incorporate it into our workflows at my place of employment. I was wondering if it is possible to create an interactive F-N chart (like what is shown below) in qlik sense that can be filtered based on the data that is in an excel spreadsheet?

Hi,

I'm working on a database of reports that get generated every day. Each day, for one of the charts, I would like to see the analyzed data only for the latest report date. 

For example. in a particular table, I would like to see the sum of EstSales according to various groups of products, but only for the latest report date.

I've used the following formula but it gives me an error.

If I substitute max([Report Date]) with the actual date '21/01/2020', using the following code below, the formula works fine. But this would entail me changing the date in the formula manually daily.

Sum({$<[Report Date]={'20/1/2020'}>} EstSales)

Interestingly, the formula max([Report Date]) works fine when I'm trying to display this in the title of the chart. But somehow does not work in the expression i'm using for the calculation

Eg. ='Jobs by Part Number as of ' & max([Report Date]) shows up as "Jobs by Part Number as of 21/1/2020"

Is there something wrong with my set analysis formula or do I need to use a different date formula to achieve the correct result?

Thanks very much!!

Hi,

I have an odd issue with my section access.  Only ADMINs are getting access (not USERs), so I loaded my section access into a table to see what it was doing. That's when I discovered if I include a mix of ADMIN and USER users, only the ADMIN ones are loaded. If I change it to be only USER (or even add in some others like TEST, DUMMY etc) , then it loads everything. I've tried loading the section access inline and also from an xlsx file.

My section access script:

Section Access;

LOAD * inline [

ACCESS,USERID,COST_CENTRE
ADMIN,ABCDE\abc1111,*
USER,ABCDE\def2222,1000
USER,ABCDE\ghi3333,2000
];

section application;

My table script:

TEST:
LOAD * inline [
ACCESS,USERID,COST_CENTRE
ADMIN,ABCDE\abc1111,*
USER,ABCDE\def2222,1000
USER,ABCDE\ghi3333,2000
];

So my question is, how am I supposed to have ADMIN and USER in section access? Or am I supposed to only have ADMIN or USER, not both?

We have published dashboard where user has created community sheet and now wants me (admin) to make this part of Base sheet.

Question:

1. When i go to view app in published stream as a ROOT ADMIN should be able to see all the user created sheet? Currently this is not the case. I am not able to see all the sheet users created only the ones that were posted in community. When i Right click on community sheets, I don't get "Approve" option. 
2. If answer is NO to above question then how do you approve sheets as admin for other users. 
3. what is the correct process and how do rest of Admin in community handle this process. 

New to QlikSense, thx for help. 

Hi All,

Our database is on Sql Server Management Studio. And we use R Script too. We were using Qlik sense Desktop but recently we decided to migrate from Qlik Sense Desktop to Qlik Sense cloud. Could you please suggest the system specification required?  What is the common practice to use - qvd or csv files?

Thanks beforehand.

Kind Regards

Hi,

Recently a client decided to migrate from Cloud to On-premise. We applied a signed license key (the same as used on Cloud); after assigning the licenses (professional), the following error appears 'you have no access pass'. We tried with analizer license too on published apps, but nothing seems to work.

Can someone explain me what I'm missing?