Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Can you give some example how to gives access group level qlik sense section access.
I have some requirement like below:
let's we have Total 6 user: They are divided into 2 Group.
How to Give access 2 group different level country access.
ex: 1st group need IND,USA access
2nd group need UK,AUS access
I have provided the Data below
Sales:
Load * inline
[
Year, COUNTRY,Sales
2019, IND, 100
2020, IND, 200
2021, IND, 300
2019, USA, 120
2020, USA, 220
2021, USA, 500
2019, UK, 350
2020, UK, 650
2021, UK, 150
2019, AUS, 850
2020, AUS, 750
2021, AUS, 450
];
I have a bit of a strange problem; I admit I'm not the best at Set Analysis syntax in Qlik. I am trying to get a count of records where the return_date is between the trigger_date and trigger_date + 30/60/90/180/365/730 days.
I have tried the following formulas to no avail; it either miscounts the 30 days, or doesn't count them, or if it does when I change it to a larger value like 365 days it doesn't count them at all, what am I doing wrong here?
I did try this solution but it does not work for me.
Attempt 1:
=Count({<[Return_Dt.autoCalendar.Date]={">=$([Trigger_Dt.autoCalendar.Date]) <=$([Trigger_Dt.autoCalendar.Date]+30)"}>} Distinct RecordNum)
Attempt 2:
=Count({<Return_Dt.autoCalendar.Date={">=$(=Trigger_Dt.autoCalendar.Date) <=$(=Trigger_Dt.autoCalendar.Date+30)"}>} Distinct RecordNum)
Attempt 3:
=Count({< [Return_Dt.autoCalendar.Date]= {">=([Trigger_Dt.autoCalendar.Date]) <=([Trigger_Dt.autoCalendar.Date]+30)"} >} Distinct RecordNum)
When I create a credential for Sharepoint (in either Personal , Shared or Data spaces), I am able to retrieve files successfully. However we were not able to share this data connection with anyone (even admins).
In other words, if another user tries to use the data connection in a load script, we get the following error message:
Cannot open file 'lib:xxxx' (Connector error: No refresh_token found for Office 365 Sharepoint).
Our expectation is that the token would be saved for the connection not having to generate a token for every single user. Also if it's not the case, how can we schedule a reload if the data connection can only work for a single user?
Hello,
I have this load script for one of my app in Qliksense.
Table1:
Load
First_Name,
Last_Name,
Salary,
Fiscal_Year
SQL Select
FirstName as First_Name,
LastName as Last_Name,
Salary,
FY as Fiscal_Year
From XYZ_Table
In the sheet, I have this simple table with Fiscal_Year column that shows all the data for all the years.
User requested to filter the data to only shows the current year and two previous years. I have adjusted my code to this:
Table1:
Load
First_Name,
Last_Name,
Salary,
Fiscal_Year
SQL Select
FirstName as First_Name,
LasrName as Last_Name,
Salary,
FY as Fiscal_Year
From XYZ_Table
WHERE Fiscal_Year >= (YEAR(GETDATE())-2); //to get only year 2024 and 2023,2022//
It loaded successfully and I got no errors, but when I go to my table in the sheet, I still see years from 2016-2021
I am not sure what I am missing. Could someone please help me with this?
thank you!
Hello,
As soon as I am trying to upgrade QlikSense, I have this error message display
"Value cannot be null.
Parameter name: format"
Is there a way to fix it ?
Thanks
After upgrading from May 2023 patch 9 to February 2024 on our test environment, we can no longer access our data connections via the browser, but we can only access the data connections directly on the server. Our developers and users access qlik sense through a virtual proxy on the browser. It seems that the underlying URL to make a data connection no longer points to the virtual proxy, so we get 400 "The http request header is incorrect".
Our production environment does not have this problem (version may 2023 patch 9).
In the attachment I have added screenshots of the test environment and the production environment. In the developer tools of the browser you can see that the proxy reference is not there in the test environment, but it is in the production environment.
Is this a bug or could there be something else going on?
I'm developing an AR dashboard and I'm having trouble figuring out how to implement a days sales outstanding (DSO) metric for the entire company.
I'm successfully using the following expression to calculate DSO at the customer level:
sum(AMOUNT_DUE_LOCAL*Days_Past_Due)/sum(AMOUNT_DUE_LOCAL)
But when trying to use the following expression to calculate it for the entire company (while weighting a customer's total amount due relative to the entire company's amount due), I run into an error:
Sum(
aggr(
Sum(AMOUNT_DUE_LOCAL * Days_Past_Due)/Sum(AMOUNT_DUE_LOCAL), CUSTOMER_NUMBER)* Sum(AMOUNT_DUE_LOCAL))
/ Sum(TOTAL AMOUNT_DUE_LOCAL)
I've attached a simple Excel example of the desired functionality to clearly demonstrate what I'm trying to do.
Any thoughts?
Hello,
I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter
if(Gender='F','Female',if(Gender='M','Male')). it works fine.
Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.
I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')
the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.
could someone help please?
Thank you!
Today we had an error on one of our Qlik Replicate tasks "Failed to remove file:"
Processing aborted due to error 300002:1355844283; incident 3722464.
to execute statement: REMOVE @"PROD"."PUBLIC"."ATTREP_IS_PROD_bf071f72_b1f9_4dc7_b2f8_919759658d9c"/bf071f72_b1f9_4dc7_b2f8_919759658d9c/0/CDC00000215.csv;
What does this error mean?
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!