Dears,

Has anyone experienced connecting Qlik to Oracle Opera on cloud database?

What i know is that we cant access the database directly.

Has anyone worked with such case before or can provide me with further assistance?

Any help would be appreciated.

Thank you

rodrigue.saade‌

I'm loading data that is formatted as ISO 8601 duration string.  Below are some samples from the data set. 

Each string always starts with "P," which designates Period, and "T" which designates Time.  The rest of the string  may contain H (Hours), M (Minutes) or S (Seconds) along with numbers for each time element.  

For example, the string "PT1H3M11.312S" represents 1 hour, 3 minutes, 11.312 seconds, which translates to 3791 seconds.  

Question: is there a script function that will convert an ISO 8601 duration string to seconds?  

I'm hoping there is a function so that I won't have to parse out the time elements individually.

Samples from my data:

Hi,

I'm trying to tune a slow app (171m rows), complicated data model and complex script. 

Question 1: There are 2 fields with long ID numbers, they have high unique values. They are used in charts for count. Is autonumber() a good and safe way to go?

Question 2: A link table linking fact table and dimension table, using an id field which has high unique values. This link table is 2nd largest table because of the id field. Not sure how to remove the link table. Do you have any suggestion how to tune it?

BEst regards,

Susan

I am developing an application in Qlik.I close my sesion of my computer with my application open and the next day I wanted to continue working on it when suddenly I stop operating, I closed the app and I wanted to reopen and the message was "an error has occurred" Damaged data.

How could I recover my application?

I have 6 dimensions and 2 measures in the policy table. And have to create an adhoc report on that. Also need to show only current fiscal year data in report. Please suggest senario for that.

Hi

I have this strange functionality where i do not need to apply the filter for 1 of the list box when selected which i was able to get...but still when i select a value from It the stragiht table which has the list box field as dimension is changing its order

and the selected value is showing up first in the stragiht table....is this something i can avoid

to ignore the selected value i have this expression

Sum({$<[Analyst Name]=,REDUCTION={"EQUITY"},Action={"Opened Report"}>} ReadCounter)

This is an example of how it looks like in the file - how do i restrict the straight table from this behavior??

Hello,

I am using Nprinting pixel perfect report to print profiles of employees. I have created Detail Report- emp id as my first level. In this level I am populating emp name and few other objects. There are 4-5 more levels to populate tables after that.

I want to repeat the contents (name etc) in Detail1 of level 1 to every page for an employee. Wanted to check if we can repeat teh contents of first level in page top for every page for an emp id.