Welcome to Qlik Community

is there a way in the load settings to change calendar year to fiscal year?  I want the 1st month to be Oct and the last month to be sept.

Thanks,

Maria

Hello - I have a simple pivot table which pulls department and accounts.  I used bold expression in the text format so the Dpt# and Dpt desc columns are in bold.  It's working for all departments except for 6405, which only has amount in 1 GL account.  I tried different styles in the Option but none of them would bold this department.  Could you please help me find a way to bold this like all others?  Thank you.

Hi Team,

I am exploring Qlik Replicate. In that, I need to create user defined function.

As per the user guide, i tried to create but can't able to create the user-defined function.

Could you please guide me/suggest the steps to create user-defined function in Qlik Replicate.

Please find the attached screenshot for your reference.

Looking forward for your reply.

Hello!

I'm a new user to a Qlik Sense Business. I'm interested to use my Qlik Sense Business license to authenticate my Qlik Sense Desktop.

I have followed the instructions. I went to the profile on my QSB environment and clicked authenticate Qlik Sense Desktop.

Linking does happen and I can see my QSB environment information in Qlik Sense Desktop.

When I click to authenticate, it takes few seconds and Qlik Sense Desktop crashes. I have the latest version of Qlik Sense Desktop and I downloaded it from my profile site from QSB.

What is it? I need to get also the Qlik Sense Desktop to work.

Hey Guys,

We are having a very huge data set (more than 200 GB) which also needs to be incrementally updated after the bulk update. I have loaded a little bit and am already running into performance issues.(I have tried creating QVDs and direct DB loads both and I have already reduced the number of columns that are being extracted) Can some one please suggest what can be done to implement this. The stakeholders actuallly want to extract 3-4 years of data from the dashboards as well. I am pretty new to Qlikview and have not handled this much amount of data in qlik dashboards before. Any suggestions on what process I can try?

Are there options to archive the data and only load it on the dashboard when someone is trying to extract a specific data set? But even if I keep the minimum the data set for a year would also be pretty huge.(20 million rows a month) Thanks.

Hi Everyone,

I am stuck with aggr() function issue in QlikSense App. I am using Aggr() function in my expression, and inside the measure, I have restricted few filters while calculating it using set analysis, the same filter restriction should apply to the dimension as well. I tried using Set analysis on dimension, but it doesnot work . Please help . 

Below is my expression :

aggr(if(RangeSum(Above(SUM({<Period=,Date={">=01/01/2019<=30/06/2019"}>}SPEND_ACTUAL), 0, RowNo()))/sum( {<Period=,Date={">=01/01/2019<=30/06/2019"}>} TOTAL SPEND_ACTUAL)<=0.80,PARENT_SUPPLIER_ID),
(PARENT_SUPPLIER_ID,(=SUM({<Period=,Date={">=01/01/2019<=30/06/2019"}>}SPEND_ACTUAL),Desc)))

In this expression, I want to avoid filtering PArent_Supplier_ID diemsion on Period as well but it is not working , Because of that even when I applied restriction on whole measure, the measure still filters on PEriod and calculates the wrong value.

Please help

Hi All,

I am facing an issue while loading data from PostgreSQL via   source connection when i load the logs

below are the logs from QDC

2020-06-17 17:10:45.270: Starting job: cate.categories.20200617171023 2020-06-17 17:10:45.272: Started loading into dock. 2020-06-17 17:10:45.287: Watching for process completion/termination. 2020-06-17 17:10:45.456: Task DockHandLoader failed: IOException: Mkdirs failed to create file:/datacatalyst/loadingdock/cate/categories/20200617171023 (exists=false, cwd=file:/usr/local/qdc/apache-tomcat-7.0.94/webapps/qdc/WEB-INF/classes)

thanks 

Hi all

I am using the weekname function to get a combination of the year and the week from a date. However, the resultant week returned by the weekname function is one week behind the week function. I assume the weekname result is wrong. Below is what I mean:

Qlik Sense example

The date in the above screenshot is actually the same as in the help file's example (which returns 2013/02 when they do it (which is what I want)):

Help file

We don't change any of the initial variables that are used for calendars and I would expect the Week and Weekname functions to be affected by it the same way anyways.

I'm not sure if anyone has experienced the same thing or if you can let me know whether you get different results. I would like to see if it is something related to Qlik or whether it is related to our setup.

Thank you in advance!

@tresesco @Vegar 

Hi Experts,

I am working in Qlik Desktop environment and want to create a sample mashup for demo purpose from dev-hub (local host). Unfortunately I am unable to do so as dragging objects into a grid layout mashup (default) is just showing blank white space with a cancel icon.

Additional Info: I am able to include objects from all apps, expect one single app (This app uses many extensions, some with ability to add custom CSS styling)

Unable to identify the cause for this behavior. Could someone please shed some light into why this could be happening (what I am doing wrong). Thanks!