Hi Techies,

I have configured shared persistence and made connection with Central node. My App size is 30 MB and user list is 300 users. Can anyone guide me how to calculate the best RAM and virtual cores config for Qlik Sense server and N Printing Server and what about if multiple N printing task runs concurrently ?

Thanks in advance!

Rohit

I have a use case where I have to limit the dimension list based on user selection.

In the datamodel, there is a flag which will decide to display the "customer_id",

Flag column filed name: Grant, value: 'T'

I'm using this below expression, which is not working, it displays all the customers

For: aggr(only(${<[Grant]={'T'}>}customer_id),customer_id)

Please help me to resolve this issue

I have a simple table with 3 columns:

Date 1 containing dates

Date 2 containing different dates

ChosenDate containing either the value Date1 or Date 2.

For each record I would like to see a field called NewDate which is either Date1 or Date2 depending on the value in ChosenDate.  Currently I tried $(ChosenDate) as NewDate but no luck.  Any suggestions?

Hi,

I'm trying to find documentation for the TLS version that Qlik Sense supports, but all I find is rather outdated.

Does anyone know if TLS 1.3 is supported, and how to disable other (older) TLS/SSL versions?

Cheers,

Vegard 🙂

I have a Date I am pulling in from a qvd formatted YYYYMMDD. I have tried everything to reformat and get the date to be just YYYYMM format. No matter the formatting I try, the closest I can get is the correct format, but then duplicates of dates like the Day is still attached. I tried Floor to remove it and group them again, but to no avail.

This is the script currently getting me the closest, but still duplicates.

Date(Floor(DATE#(DATEFIELD,'YYYYMMDD')),'YYYYMM') AS NEWDATE,

It's been awhile since I've played with Qlikview so please ignore my ignorance.  I have the following:

Customer Table

• Cust_ID
• Customer_Open_Date

Deposits Table

• Cust_ID
• Deposit_Date_Added

I'm trying to create ONE  master calendar so when I click Year it filters on both the Customer Open Date  AND the Deposit Date Added.   For Example, I want to look at accounts that have customers opened in January 2019 AND ALSO Deposits Opened in January 2019.  I don't want to have Customers Opened In January 2019 and Deposits In February 2019.  In SQL I would write the statement like this:

Select *

From Customers inner join Deposits on Customers.Cust_ID = Deposits.Cust_ID where Customers.Customer_Open_Date Between '01/01/2019' and '01/31/2019'  AND Deposits.Deposit_Date_Added Between '01/01/2019' and '01/31/2019' 

When loading the data into click I take out the Where clause because I want to allow the user to use a date range for both fields.  Any idea how to do this?  I have already tried the Canonical Date approach unsuccessfully.  It's not bringing me back the results I want.  Any other idea how to make this happen?

Folks

Can someone advice how to create a chart for sample data requested below,
Metrics is a dimesion - which has Inventory Beginning of Month, Work Items Received, Work Item Completed
and Month as another dimension which as show below. Work Items and Counts are measures under each of month.

Is it possible to come up with 2 dimesions to present data as below. I can compute measures Work Items and Counts.

Appreciate any ideas please?

Hi All,

I have a question. Can we connect from QlikView to Oracle Database log files and pull the data into Qlikview. If any one knows please give your reply. Thnaks in Advance.