Hi,

I have a stacked bar chart with two dimensions (Store Type and Customer Type), and one measure (Sales Quantity).
I want to display the segment labels (the breakdown by Customer Type within each Store Type) as percentages, while showing the total labels (the total sales per Store Type) as absolute numbers.

For example, in Store Type A there were 500 sales in total - 150 sales from Customer Type S (which is 30%), and 350 sales from Customer Type L (which is 70%).
In the segments, instead of showing the absolute values (150 and 350), I want to show their percentages of the total (30% and 70%).

Is there a recommended approach to achieve this?

Thanks!

Hi,

We have a source db2 i series and the parameter record images is only *after configured.

When in the source has inserted a new record, then in the target that is aws s3, we view 2 records an insert and an update for the same record.

This is posibble and caused by the parameter record images?

thanks.

Hi All,

I have tried multiple options to sort the pivot -cross table in qlikview for the "Total" in descending order for each Name, but didnt work . If anyone has resolved this , kindly share the solution 

sample :

load * inline [
Name,Category, TagName , Value
ABC, Bird ,XYZ,300
ABC,Animal,YYY, 200
CDE,Bird,ZZZ, 100
CDE,Pet,YYY,300
ABC,NonPet,XYZ,150

];

Hello everyone,

I'm struggling with a script where the keys are not working as expected.

I have a fact table with only three fields (although I have more in total, but created this in order to simplify), and later I create a final table with all the fields I need, properly transformed.

After that, I need to create a table with some filters and specific requirements.

rds_telemonitoring_alarm:
LOAD id as alarm_id, 
	account_number, 
    IF(date(FLOOR(datetime_edp_preprocessing)) >= Today() - 30, 'Lower 30 days', 'Greater 30 days') as has_recent_alarm_30_days //NEW2 
    
FROM [lib://QVD.01.Stage/FSM/tlm_historic_alarm.qvd]
(qvd);

//---------------------------------------------------------

rds_telemonitoring_alarm_final:
NOCONCATENATE
LOAD 
	alarm_id,	
	account_number,
    has_recent_alarm_30_days
RESIDENT rds_telemonitoring_alarm;
DROP TABLE rds_telemonitoring_alarm;


//---------------------------------------------------------
accounts_active_with_alarms_last_30_days:
LOAD 
    account_number,                            // Identificador único de la cuenta
//     Count(alarm_id) as num_alarms,
    IF( (Max(Date) >= Today() - 30), 'Lower 30 days', 'Greater 30 days') as has_recent_alarms
RESIDENT rds_telemonitoring_alarm_final             // Fuente de datos: tabla cargada con las alarmas
WHERE 
      // Alarmas ocurridas en los últimos 30 días
    telemonitoring_contract_active_flag__c = 1  // Cuenta con contrato TLS activo
    AND (tls_contract_end_date__c > Today() OR IsNull(tls_contract_end_date__c))  // Contrato sin fecha de fin o aún vigente
GROUP BY 
     account_number; 

However, when I select "Has Recent Alarms" > "Lower 30 Days", it doesn't return alarms from the last 30 days. Instead, it shows alarms with a datetime older than 30 days.

 With the ERD,

Hope anyone can help me out

Thank you 

Hi all,

I'm working on creating an extension that will automatically trigger a refresh of dynamic views in an app on Qlik Cloud. I'm struggling to find anything much in the way of documentation for this - there's a bit for on-prem, but nothing that I can find for cloud.

The goal is to to have the extension perform exactly the same function as is executed when a standard button is set up with the 'refresh dynamic views' action, but triggered automatically by a set of determined criteria (not important for this question)

I've been able to extract from the browser's network tools that the button does the following:

GET to /api/v1/odaglinks/[long identifier number]

POST to /api/v1/odaglinks/[long identifier number]/requests

What I'm looking to find, however, is an API call that will provide the actual identifiers, so that I can make my extension retrieve all of the links on the sheet and then execute the refresh command.

Any assistance or pointers to documentation that I've been unable to find is appreciated!

Thanks!

I have an app that holds data for our entire company.  I want to limit the data that is returned when a user views the sheets to only the employees that report to that manager.  Is the only way to do this, without creating multiple versions of the app, to use section access?  We have user groups but no set up currently that outlines our company hierarchy so would I have to also set up groups that divide the employees into each manager?  My goal is to do this with the last amount of manual up keep being required.  We are using Qlik Sense SaaS.

Hello,

We configured a report task to send a report daily to 3 users. We've seen that the report is sent twice and that 1 of the 3 people receives it twice. The 2 others receive one email/report. 

Also, while testing with another task intended for the users with no issue, no double report is sent.

Could you help us solve this problem ?

Hi all,

We are developing an ELT process using oracle merge, where a column to be updated needs to have as the new value the greatest between the new value and the target current value.

In sql it would be something like:

Hey everyone!

I’m looking to convert a Sum(If) expression into a set analysis format.

Sum(
If(IsNull( %TransCode ) or Len(Trim( %TransCode )) = 0
or
(Len(Trim( %TransCode )) > 0 and (IsNull([Transaction Type]) or Len(Trim([Transaction Type])) = 0)),
$TransAmtLocal
)
)