Hi techies,

I have a use case where I need to delete Qlik app sheets which are unused since last one year. I have collected the concern sheet ids from operation monitoring app. Lets say concern sheets are 500 from 1 app. I am looking for a way that I delete such sheets from   repository API by picking sheet ids from external sheet which has sheet id exported from operation monitoring app.

I have found a document which has information how to delete single sheet in one request but I need to send request for all 500 sheets in one go, like picking sheet id one by one and send request to QSR database via API.

https://support.qlik.com/articles/000055464

Please help me to achieve my goal

Thanks in Advance

Rohit

Hi everyone,   

I need a bar graph that shows average profit on rims and tire sales (hypothetically) for each car brand grouped by month (picture at bottom)

So imagine on the left of the graph the annual profit per car sold of Hondas each month (12 bars, one for each month) and then next would be the same thing for Toyota, etc.  The height of the graph would be average profit per car.

Ideally this would be both a grouped graph and a stacked graph, but that capability doesn't exist.  So the height would be the sum of the averages.  So, for example, if the company averaged $1,000 in rim profits per car, and $100 in tire profits per car, the height of that bar would be $1,100 in wheel profits per car (not $550, which is what the average function would give me).

I want a filter that would show the average if it was just Rims, just Tires, or both Rims and Tires.

Here's an example of a piece of the table:

BRAND  TYPE  PROFIT UNITS  MONTH
Honda    Rims  $10,000  10   March
Honda    Tires     $1,000  10   March
Honda    Rims  $12,000  12   March
Honda    Tires         $600  12   March
Nissan    Rims  $10,000  10    April
Nissan    Tires     $1,000  10    April
Nissan    Rims  $26,000  13    April
Nissan   Tires      $1,950  13    April

I wrote this expression, which gives me what I want, except that the filters don't operate when it is written this way:

Sum({<TYPE={Rims } >}PROFIT) / Sum({<TYPE={Rims } >}UNITS) + Sum({<TYPE={Tires } >}PROFIT) / Sum({<TYPE={Tires } >}UNITS)



Note:  I created this report in another application and was able to work around this by adding a row called "total" under TYPE which would be the subtotals.  Then, in the application they could select Rims, Tires, or Total and I used a feature that forced the user to always have exactly one choice selected.


Thanks!

The data warehouse we are connecting to has data in tables stored vertically and horizontally. All the ones that are horizontally stored I am having no issues with. However the vertical ones I am.

The load statement is the following (Simplified):

CROSSTABLE(item, TEXT_VALUE, 3)
LOAD
    [ID],
    [PREV_ID],
    [SUB_ID],
    [FIELD_NAME],
    [TEXT_VALUE]
    [NUMBER_VALUE];

Currently the data is in this format in the MySQL database.

I need to make AMT, VALUE, HTS, HTS DESC, have their own columns, with the data associated with them.

Such as

I tried using a CrossTable, but not seeming to get results that would work. Any suggestions on what I should use or how to get this better setup better?

Note PREV_ID links to the KEY in the parent table, and SUB_ID links it to the Part Number associated with these. Some have 50-100 part numbers. So these get huge very quickly. I requested these be split out, but didn't resolve the issue as more empty lines were created which made it even harder as more columns and more blank rows of data with 1 value in AMT, VALUE, HTS, or HTS DESC.

Our data warehouse is always one day behind. This makes true inYTD comparisons unequal unless I subtract.

For example, on 4/2. If I'm doing a comparison between the current year and the previous year, I'm comparing data up to 4/1 in the current year but 4/2 in the previous year.

I'm using an auto-calendar but I don't see a "DaysAgo" option. 

This is my current set analysis for the previous year's Sales measure. I need this to be inYTD, 1 year ago, but also one day before to make it equal. Does anyone have any recommendations?

Sum( { $< [INV_DATE.autoCalendar.InYTD]={1}, [INV_DATE.autoCalendar.YearsAgo]={1} > } [SALES] )

Our primary user directory is tied through LDAP to our company's domain.  Because of the COVID-19 situation, we are furloughing some of our workforce.  Management wants their Qlik access removed during this period.  They are not disabling the account through AD so the users remain active in Qlik.  Is there any way to override this and inactivate the users temporarily through a secondary process using an API?

Hi Guys:

We would like to know what is the best approach to modify the Attunity Envelope sent by the Qlik Replicate to adhere to some of the principles of the CloudEvents 1.0 specification. https://cloudevents.io/

The Cloud Events Specification seems to be very flexible and some of the fields included at the Attunity Envelope comply to it. This is the Attunity Envelope in YAML for readability purposes (Please imagine this is a JSON file)

type: record
name: MessageEnvelope
fields:
    - name: magic
      type: fixed
      size: 5
    - name: type
      type: string
    - name: headers
      type: map
      values: string
    - name: messageSchemaId
      type: string
    - name: messageSchema
      type: string
    - name: message
      type: bytes

This is an example of the Cloud Events Specification 1.0 in YAML.

specversion: '1.0'
type: com.example.someevent
source: /mycontext
id: C234-1234-1234
time: '2018-04-05T17:31:00Z'
comexampleextension1: value
comexampleothervalue: 5
datacontenttype: application/json
data:
    appinfoA: abc
    appinfoB: 123
    appinfoC: true

On our understanding, this is similar to the envelope 

type: record
name: MessageEnvelope
fields:
    - name: specversion
      type: string
    - name: type
      type: string
    - name: source
      type: string
    - name: time
      type: timestamp
      value: '2018-04-05T17:31:00Z'
    - name: comexampleextension1 # This is extension
      type: string
      value: value
    - name: comexampleothervalue
      type: string
      value: 5
    - name: id
      type: string
    - name: datacontenttype
      type: string
      value: application/json
    - name: data
      type: json
      data:
        appinfoA: abc
        appinfoB: 123
        appinfoC: true

Just to reformulate the question, what is the best approach to extend the Message Envelope from Qlik Replicate to accommodate the fields from the Cloud Events specifications which are not found. This is very useful as it would allow to simplify the monitoring among other things.

Kind regards

Gonzalo Pérez-Prim

Hello,

Please find attached my sample Qlikview doc.

The Asssignments table is my main table. It has 2 rows with 2 dats.

My datebridge table has 4 rows. I want to get the two rows from the Assignment table and eliminate duplicates.

The count of file number should only be 2 in the datebridge table - 1 for each date in the Assignment table and not 4

Please advise as to how.

Thanks

Shashank

Hi,

Is there any option, to maintain the historical data from source to datalake using attunity replicate. I know that Qlik also has attunity compose for datalake. But instead of taking another tool, is there any option to maintain historical data in replicate tool itself. 

Instead of creating the change tables, the main tables itself should maintain the history of the record for past some days , say example : past 7 days data.

If so please let me know. Appreciate your help.

Thanks,

Deepthi.