Hello Everyone, I have a question for Qlik sense. I have a table that has a Date column and a quantity column. I need to create a master Item that calculates the month to date quantity. 

I am attaching an Excel file that has those 2 columns and also the column of the MTD that I need to calculate as a master item

Can you please Help ?. Thanks

Dear all,

after several attempts, i need your help.

I have 2 tables composed as follows:

HIRE which contains the following fields:

HIRE_CODE HIRE_DATE (date field)

END_DATE_F (date field)

BRIDGE which contains the following fields: HIRE_CODE PREV_CODE START_DATE (date field) END_DATE (date field)

In the BRIDGE table, the period for which the PREV_CODE is valid for that hire (HIRE_CODE) is indicated.

I would like to create a new table where for each hire (PREV_CODE), the valid PREV_CODE is indicated for each month within the period indicated from HIRE_DATE to END_DATE_F.

The table I expect might be:

HIRE_CODE

PREV_CODE

YEAR

MONTH

Thanks for your support

Mauro

Hi,

I want to download private files related to an opportunity in Salesforce. I've tried tfileFetch but it doesn't work.
I've tried using APIs but I can't make the link between the opportunity and the file to be uploaded to Salesforce.
Have you ever had this problem? Do you know how to retrieve these files? 

Thanks

@Dataintellinalytics 

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

Data:

Expected outcome in Pivot Table

Hope you can help me to solve this requirement 🙂 

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 There,

I have two tables, and unfortunately, I should not join them. However, I want to apply the conditions below.  In the model viewer i can see that table 1 and table 2 got  the connection using the ID as primary key.

I appreciate your help to achieve the below condition.

Tabe 1 got raised_date and the primary key is ID

Table 2  got survery_Date and the primary key is ID

and the condition i want is below  

WHERE (table1.raised_date> table2.survery_Date OR IsNull(table1.raised_date);

we are working on building some solution around qlik task log. We want to analyze qlik task log at some interval and parse all qlik task log. Parse log and if there's any failure or warning, we want to highlight on dashboard that will be built on some other tools.

Is there way we can fetch from replicate server (window server), do parsing ?