Is there a way to create a custome tooltip or hover when we hover on top of the kpi or graph to explain it's about? I can't see to add that in at all or is there an alternative then when it hovers instead of showing a value it displays a description of what that graphs/kpi is about? 

Hi,

loading multiple qvd's from qvd folder using wildcard load at qvd path.

storing data into day wise qvd's and one field added in yesterday qvd.

" digital_campaign_code " field added in yesterday's qvd and values not reflecting.

thanks in Advance

below is my script :

Activation_Temp:
Load
'' as SupplementaryFlag,
'' as UploadDocumentFlag,
'' as ApproverUserID,
'' as ApprovalRemarks,
'' as ApprovalJustification,
'' as ApprovalStatus,
'' as digital_campaign_code
AutoGenerate 0;

Concatenate(Activation_Temp)
Load
OrderActionID,
PackType,
SimSerialNumber,
MNPInd,
DonorOperator,
PortinStatus,
PortInReason,
ActRejectReason,
ActDeviceName,
ActDeviceBrand,
ActDeviceModel,
ActDeviceSIMType,
ActDeviceColor,
ActDeviceSKU,
ActPreToPostInd,
ContractName,
ContractDuration,
ContractStartDate,
ContractEndDate
//digital_campaign_code //new
FROM
$(vQVDfolder)/OrderActivationDtl/OrderActivationDtl*.qvd(qvd);

NoConcatenate

OrderActDtl:
LOAD OrderActionID,
PackType,
SimSerialNumber,
MNPInd,
If(MNPInd=1, 'MNP') as MNPIndVal,
DonorOperator,
PortinStatus,
PortInReason,
ActRejectReason,
ActDeviceName,
ActDeviceBrand,
ActDeviceModel,
ActDeviceSIMType,
ActDeviceColor,
ActDeviceSKU,
ActPreToPostInd,
ContractName,
ContractDuration,
ContractStartDate,
ContractEndDate,
SupplementaryFlag, //NEW
UploadDocumentFlag, //NEW
ApproverUserID, //NEW
ApprovalRemarks, //NEW
ApprovalJustification, //NEW
ApprovalStatus, //NEW
digital_campaign_code //new
resident Activation_Temp;
// FROM
//$(vQVDfolder)\OrderActivationDtl\OrderActivationDtl*.qvd(qvd);
drop table Activation_Temp;

exit Script;

Hello,

I will want to display the average of my MTBF (column 1) of the name (Name column) of the non-empty rows of the sector_mtbf column

How to proceed

thank you

Hello 

payload =

{
    'sub': 'AbVUmy-qm52KYnW3LLUMVj8XL9b_w_Xw',
    'subType': 'user',
    'name': 'Anton Akhramovich',
    'email': 'anton.akhramovich@leverx.com',
    'email_verified': True,
    'iat': datetime.now(tz=timezone.utc),
    'exp': datetime.now(tz=timezone.utc) + timedelta(hours=6),
    'iss': 'ipivg15a4pg4614.us.qlikcloud.com',
    'aud': 'qlik.api/login/jwt-session',
    'groups': ["Analytics Admin", "Data Admin", "Data Space Creator", "Developer", "Managed Space Creator",
               "Shared Space Creator", "Tenant Admin"],
}

options = {
   "keyid": "a9e1e157-b9a1-40da-8926-d2d022ab25eb",
   "issuer": "ipivg15a4pg4614.us.qlikcloud.com",
   "expiresIn": "6h",
    "algorithm": "RS256",
   "audience": "qlik.api/login/jwt-session"
}

curl --request POST \
  --url 'https://ipivg15a4pg4614.us.qlikcloud.com/login/jwt-session?qlik-web-integration-id=4X19wW0KeJFDF_cSYIsDLoeUPN98kuqG' \
  --header 'Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsImtleWlkIjoiNzM4MWVhMzItYTYyYi00MzE1LWE1NTAtNDE5NTA0NjkwMDhlIiwiaXNzdWVyIjoiaXBpdmcxNWE0cGc0NjE0LnVzLnFsaWtjbG91ZC5jb20iLCJleHBpcmVzSW4iOiI2aCIsImFsZ29yaXRobSI6IlJTMjU2IiwiYXVkaWVuY2UiOiJxbGlrLmFwaS9sb2dpbi9qd3Qtc2Vzc2lvbiJ9.eyJzdWIiOiJBYlZVbXktcW01MktZblczTExVTVZqOFhMOWJfd19YdyIsInN1YlR5cGUiOiJ1c2VyIiwibmFtZSI6IkFudG9uIEFraHJhbW92aWNoIiwiZW1haWwiOiJhbnRvbi5ha2hyYW1vdmljaEBsZXZlcnguY29tIiwiZW1haWxfdmVyaWZpZWQiOnRydWUsImdyb3VwcyI6WyJBbmFseXRpY3MgQWRtaW4iLCJEYXRhIEFkbWluIiwiRGF0YSBTcGFjZSBDcmVhdG9yIiwiRGV2ZWxvcGVyIiwiTWFuYWdlZCBTcGFjZSBDcmVhdG9yIiwiU2hhcmVkIFNwYWNlIENyZWF0b3IiLCJUZW5hbnQgQWRtaW4iXX0.A_s2kfGijAkigtZ24hNpEj1npN5mtNVYsD36k08Xl3lDAhUXL-cwbVc-w9i_ito8JU0S4GTnb-I6mCUtibgT35LOfu7jIyguzuT-EQIuRsAlxd76Wnv9f4c9VQXhko-RPjXXT8RRENTVPwkkik1XyR57cmDtgcXq4bTIO2qp--nN1Vqczw8GPn8Z8YVqWlxnoPeOCUH8VpeqCm-zVt32YJOiQptSFg9dukuy18qfjtdu6voriepM0Y6TWfyYt8cgIEGXQ5ydNNA14lVzyCQNL1gzx9Y_7FhjRcCIlX4_cGpjhQbEa7GfkqL46SHhTZyXDVFHiNPJ3ZR-Zq6cIRjR5vVPfmsYY87HArZCRc_aE5PvQ7MM3zNLLW9wrzn-u52YQIR2uvwWEXW96NM8H_aPggI3yAK2oMXkEerZ1QMkd-nOKYgfdMql3wRSirEJCGmvIIX8sQKpFnERM7JzkGXH1pcTcbHFoAbldeC4EbTgFeK2pTxHGXN2TH1DFqZfFvPg7wnHpfJs83yZYL3w4AWwxFvZ-OF3yHr8BxZLHjTK2Mu7nSYTamR93QtZmZqrp5rszjNK_RmjgOfJdCNQlk53UJcRRhDnE8OkKLWqUXiWNDWcxP_mZGvexPI51PKpM5z1V4w5J-Wd7ETc0hguy3Cp-Q6GUvMOcTJa2-VSYvQjzsI' \
  --header 'content-type: application/json' \
  --header 'qlik-web-integration-id: 4X19wW0KeJFDF_cSYIsDLoeUPN98kuqG'

{
  "errors": [
    {
      "title": "Authentication failed",
      "detail": "No identity-provider is able to complete the exchange",
      "code": "LOGIN-1",
      "status": "401"
    }
  ],
  "traceId": "0000000000000000575fdaa5ce50c86f"

} 

Hi team,

I need help to write a set analysis with a Trend chart for the below scenario :

Need to create a bar chart to compare data between different dates and to count no of ids which were Old, New and Changed in each date. Old/New/Changed values need to be calculated on the flow if the Code is same or changed with respect to a date. Below is the example.

I want to replace field values with Zero if value is hyphen i.e. '-'.

Have tried many things like 

1. If Statement
2. Replace Function
3. Pick Match
4. Applymap

But all of these are taking lot of time to replace existing values to 0. Can I do this quickly in someway ?

Data volume is ~274,444,124

Script Example :

FinalData:
NoConcatenate
LOAD *, if(Rate='-','0',Rate) As [Rate_New] Resident Final;
Drop Table Final;
Rename table FinalData to Final;

Above block itself is taking excessive time. Around 2 to 2.5 hours

Drop field [Rate_New] from FinalData;
Rename Field [Rate_New] to [Rate];

QlikView  Qlik Analytics Platform