Hello Qlik Experts,

I am trying to create a pivot table in Qlik that shows "Current Sales" and "Previous Month Sales" for each "month year" selected.

However, I'm encountering issues with the accuracy of the figures for the previous month's sales, and I also need the pivot table to dynamically update based on multiple "month year" selections.

Data Structure:

Here is how my data is structured:

Measure for Sum of Amount for Selected Month

sum({<MonthYear,Month,Year,SalesDate = {">=$(=MonthStart(Max(SalesDate)))<=$(=MonthEnd(Max(SalesDate)))"}>} Amount)

Measure for Sum of Amount for Selected Previous Month 

sum({<MonthYear,Month,Year,SalesDate = {">=$(=MonthStart(AddMonths(Max(SalesDate), -1)))<=$(=MonthEnd(AddMonths(Max(SalesDate), -1)))"}>} Amount)

Attached is the QVF. 

Thank you very much for your assistance!

Hi ,

I need to parse and load DB a pipe delimited file having data in the below structure using Talend.

Col1|Col2|Col3

"abc|111"|100|"zzz"

"xyz|222"|200|"yyy"

• Text fields are enclosed in double quotes.
• Few text columns contain the delimiter inside them.

I am using dynamic schema as there are are multiple files with different schemas.(but all files follow the above rules).

Issue : It is note able to parse the entire content inside double quotes (abc|111) as single field.

Please help.

Thanks

Hi Team , 

We are replicating data from SQL Server to Postgresql

For SQL Server we are using MS-CDC for real time replication. But its Capture job is getting failed with error 

nested limit exceed 32.

Version for SQL server is 2017 standard edition.

Any solution or ideas is appreciated !!!

I have the following where I'm parsing raw files into a dbTable then I want to iterate to a second sub with a tForeach

See attached example screenshot

When I try to connect the tForeach2 to the Raw transactions I get an error

Thanks for any help 

Hey everyone, I'm seeking some advice:

I need to read an XML settings file and parse it to extract its contents into multiple property files, one for each environment. Everything seems to be working smoothly, but the filename is lazily set and does not match the content

Thank you

Hello Qlik Community,

We have migrated the server application data which is D(net app) drive to some F(pure) drive for the storage migration activity from net app to pure.post that we have renamed that F drive to D drive by stopping the services for both Qlikview and nprinting with the help of only Qlikview admin credentials.

Then we restated the server and started checking the qlikview and nprinting applications.

I'm able to open qlikview QMC and access point but somehow Nprinting credentials are not working for me to login ,even the admin credentials are also not working.

I'm not sure ,if this is because of the storage migration or due to the drive letter change and there is nothing changed in C drive where the application is installed.

Please let me know is there anything I need to check on this immediately.

Thanks in advance. 

In March of 2024, Snowflake announced that Hybrid Tables are now in QA.

Will the Snowflake target endpoint connector be modified to support replicating data to Hybrid Tables as well as traditional Snowflake tables? Is this on the roadmap?

https://docs.snowflake.com/en/release-notes/2024/other/2024-03-05-hybrid-tables
https://docs.snowflake.com/en/release-notes/2024/other/2024-03-13-hybrid-tables

Hi,

Recently we tried to upgrade our Qlik Sense from May 2023 to August 2023 (IR). The upgrade went well for DEV and QA servers. But it failed on production servers. We had to restore production servers with backed up AMI. Now we are investigating the reason why it failed. We have realized that we made a mistake when upgrading QS production which has two nodes: We stopped services on both nodes and then ran installation on two nodes at the same time. We know it is incorrect. But why did it cause problem? I am writing a report and need to gather deeper information.

Based on installation log files, I can tell the failure occurred at ServiceDispatcher step. Error occurred when it tried to create schema 'qlik_notifier_service'. I checked the log file for the successful installation on DEV server. When it tried to create schema 'qlik_notifier_service' there, it skipped this step because "Schema 'qlik_notifier_service' already exists" (the sentence in log). Why did the installation not skip it during production installation?

The attached ServiceDispatcher_installation_logs.txt contains related content from log files.

We need to make sure there is nothing else which caused installation failure. Please advise.

Thanks