Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Loading a QVD file from a SFTP connector (not from webconnector) occurs an error: noFileSize
Any file format doesn't have an error when loading.
I tried to load with an other QVD, the same issue persist.
Antivirus doesn't scan the SFTP folder.
There is not file access restrictions, antivirus software locking the file, or resource bottlenecks
Any idea to fix it?
Hi,
When i try to import a .qvf from local to Qlik Cloud after setting the context.
Getting the following error. What setting/permissions should i check
qlik app import -f .\Data\QlikSense\Apps\2729801f-8296-4c20-803c-82008ef68322.qvf --spaceId 66057f9caede839bf606a915
Sending Request 2s 2.50 MiB / 2.50 MiB [==================================================================================================================================================] 100.00% 1.15 MiB/s 2s
Error: 403 - Forbidden (empty response)
Thanks,
Anuradha
I am able to;
However when I try to access the sheet it's self I get the following message displayed
An error occured
and then a refresh button
A vague message with no explanation as to what I should be looking for.
Does anyone have any suggestions?
Hi Team,
We are currently on Qlik Sense Nov 2023 SR5 version.
I am configuring the Qlik ServiceNow connector and I am running into an issue. Issue is that I am just seeing the "sys_id_value" field for all the tables.
Tables I have tried to access so far are sc_req_item, sc_request, dmn_demand, pm_project tables. From my knowledge, the username has access to the tables.
@MTO @DJK Has anyone run into a similar issue?
Create a ServiceNow connection | Qlik Connectors Help
#ServiceNow
Thanks in advance!
Regards,
Sujeet
I'm currently working on the data load using IF statements below but keep getting an error for line 3 & 4. Can someone help point out what I'm doing wrong? I've included the sample data attached for reference of what I want as an outcome. Thank you in advance.
1: date(CREATED_DATE, 'MM/DD/YYYY') as [Date Opened],
2: STATUS_C as [Status],
3: if([STATUS_C]= 'Closed', 'Closed','Open') as [Status Flag],
4: If ([STATUS_C] ='Open',today()-Created Date as [Days Aged from Open Date],
5: If ([STATUS_C] ='Open',If( [Days Aged] >= 0 and [Days Aged] < 90, replace( class([Days Aged],30),'<= x <','-') & ' Days', If( [Days Aged] >= 90, '90 Days+'))) as [Open Timeframe],
Hi there,
I'm looking for a way to show sales activity done in the first month.
Currently this is only possible for the Current month as there is next month activity.
How do I call on a specific activity date in a bucket?
The metrics I (think) need to use are:
[Revenue]
[start date](in days eg. 01/01/2024, 02/01/2024, etc)
So I want the following:
Jan 2023 showing Month 1 revenue
Feb 2023 showing Month 1 revenue
March 2023 showing Month 1 revenue
etc. etc.
Is there a way to do this?
Thanks
Robert
Hi,
I have 2 tables which have some common fields. Now I want to add filters on those common fields and then when I select the filter values, both the table visuals in my dashboard should show relevant data - something as below.
To achieve this functionality, in data manager if I associate both tables by month_id then it will work fine when I make a selection in month filter alone. But if I make a selection in County filter alone (say I select Japan), then the flow would be -
I tried to create new filed concatenating both month_id and country fields. Then associated 2 tables based on this new field, but would still have the same issue as above.
Joining tables will not be an option because in my actual data there are 3 more dimensions in table_1 which are not in table_2 and I have 5 more dimensions in table_2 that are not in table_1. In that case, joining by those 2 common dimensions (month_id & country) will multiply and create many unwanted rows. Moreover, joining fact tables is not ideal either.
Appreciate any assistance on how to achieve this. Thanks!
Good afternoon,
I created two variables on my qlik app, one that identifies the current month, and one that identifies the previous month. Now I wish to calculate the difference in detections between each month, I was trying to use the following expression but got an error:
=Sum({<'$(=vCurrentYearMonth)'>} Detections) - Sum({<'$(=vPreviousMaxMonth)'>} Detections)
Any suggestions?
Detections is a defined measure in my app.
Hi,
I'm a bit new to qlik and am building a report template. I have created a filter which has a search expression as follows:
= (DueDate >= Date('01/02/2024') AND DueDate <= Date('29/02/2024'))
Is there a way to make this dynamic so that I don't have to hardcode the previous month like above etc?
Thanks for any help!
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
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!