Hi Friends

In my QV document I have loaded data relating to vehicle parts and it is displayed in a table box as  shown below. 

I want the records in Table box to be printed as labels  (to be affixed on the part)  as shown above. I think this has to be arranged a text box and then print. However I am not aware  of how to do it. I seek your help to fulfill my requirement please. 

Hello,

I have a set of data like below:-

I have to display the name of, max of this sales office in a KPI, where most cases were registered,How to write expression for this?

In this example suppose, Uttar Pradesh SO II has max of 4 cases, so it should display 'Uttar Pradesh SO II'.

Please suggest.

Hello,

I need to find rolling and YTD revenue. rolling month starts from september and ends on august. I have two years of data sep-2019 to aug-2018. i have a text object where current year and last revenue will be displayed. so, when i select rolling in the filter, in the text object revenue should displayed as currrent year rolling revenue and last year rolling revenue.

when i'm using the below code to get revenue, the current year revenue is coming up to be zero and last year revenue is getting switched with current year revenue. Attaching the screenshot of the dashboard for your reference.

='Current Year:'& Num(Sum({<[week] = {">=$(=MakeDate(Year(Today()),9,1) )<=$(=MakeDate(Year(Today())+1,8,30) )"}> } NET_SLS_AMT/1000000),'##.00')
& ' Last Year:'&Num(Sum({<[week] = {">=$(=MakeDate(Year(Today())-1,9,1) )<=$(=MakeDate(Year(Today()),8,30) )"}> } NET_SLS_AMT/1000000),'##.00')

I have two products , each product has 3 measures related to it and Month as a dimension.

I want to create a bar chart where i want to show the  stacked bars for each product for same month.n short i want to combine the grouped as well as stacked bars in same Graph.

Can anyone help me here?

Hi guys,

I would just like to seek help on how I can COUNT the occurrence of values greater AND smaller than 10.
For example, I have in the table:

ID 1000.

Numbers <= 10: only number 1;
Numbers > 10: numbers 20, 30, 40;

So the result would be:
There are 1 number <= 10 and 3 numbers > 10 -- 1 low 3 high

For the ID 1001, 2 low 2 high and so on.

And the graph would be as follows (see attachment):

My script is attached.

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

TBL_LOAD:

LOAD * INLINE [
ID, Num1, Num2, Num3, Num4
1000, 1, 20, 30, 40
1001, 1, 2, 50, 60
1002, 4, 5, 70, 80
1003, 3, 5, 90, 100
1004, 1, 2, 3, 20
1005, 7, 8, 9, 50
];
//-------------------------------

TRANSFORM_CONCAT:
LOAD
ID,

//Concatenate numbers separated by the "blank" string row by row

[Num1]&' '&[Num2]&' '&[Num3]&' '&[Num4] as Num_Concat

//1 20 30 40
//1 2 50 60
//and so on...

Resident TBL_LOAD;

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

TRANSFORM_NUMBERS:

LOAD

//Create Numbers dimension with all numbers

Num_Concat,
subfield(Num_Concat,' ') as Numbers 

Resident TRANSFORM_CONCAT;

TRANSFORM_LOW_HIGH:

LOAD Numbers,
// Here, I'm utterly confused by my count if expressions

If(count(if(Numbers<=10,Numbers)) =1 AND count(if(Numbers>10,Numbers))=3, '1 Low 3 High',
If(count(if(Numbers<=10,Numbers)) =2 AND count(if(Numbers>10,Numbers))=2, '2 Low 2 High',
If(count(if(Numbers<=10,Numbers)) =3 AND count(if(Numbers>10,Numbers))=1, '3 Low 1 High',

'Others'))) as Count_Low_High

Resident TRANSFORM_NUMBERS;

Best regards,

Hello,

I want to know if I can use PUT, DELETE, GET, HEAD in the Qlik Sense REST connector? I can choose between the following protocols in Qlik Sense:

Methods in Qlik Sense REST Connector

The Qlik Sense API for example provides many REST Endpoints we can communicate with. For example:

"DELETE  /qrs/user/{id}",

"PUT     /qrs/app/{id}/publish?stream={streamid}&name={name}",

How can I call such an request (using the mentioned protocols) in Qlik Sense?

Greetings

Hi All,

I have requirement were user want see Bar chart with current month data adding last six month data in same month like that each and every month. we need keep on adding  that month +six month in bar chart. 

Thank you in advance 

Im trying to request SaleId for this url

https://server."company".com/masterkey/agency/sale/<saleid>/saleOrder

So that I can get country and city of destination of the SaleOrder.

I want to make a loop so that every call I make, it will return the information of the saleOrder im calling.

If there is someone that could help me that would be great!!!!!

I have this already in the script

LIB CONNECT TO 'Sale';

RestConnectorMasterTable:
SQL SELECT
"__KEY_root",
(SELECT
"sort",
"order",
"max",
"offset",
"totalCount",
"count",
"__FK_meta"
FROM "meta" FK "__FK_meta"),
(SELECT
"q",
"courseType",
"status",
"interestLevel",
"referrer",
"paymentStatus",
"enrollmentStatus",
"seller",
"client",
"saleGroup",
"isEnabled",
"studentName",
"saleOrderStartDate",
"courseName",
"customStatus",
"channel",
"manager",
"__KEY_query",
"__FK_query",
(SELECT
"@Value",
"__FK_distributor"
FROM "distributor" FK "__FK_distributor" ArrayValueAlias "@Value")
FROM "query" PK "__KEY_query" FK "__FK_query"),
(SELECT
"id" AS "id_u5",
"version",
"pid",
"externalId",
"name" AS "name_u5",
"status" AS "status_u0",
"courseType" AS "courseType_u0",
"dateCreated" AS "dateCreated_u0",
"lastUpdated",
"referrer" AS "referrer_u0",
"interestLevel" AS "interestLevel_u0",
"campaign",
"formURL",
"customStatus" AS "customStatus_u0",
"saleGroup" AS "saleGroup_u0",
"isEnabled" AS "isEnabled_u0",
"manager" AS "manager_u0",
"discardReason",
"enrollmentFieldApproved",
"enrollmentFieldCount",
"paymentDueDate",
"paymentStatus" AS "paymentStatus_u0",
"enrollmentStatus" AS "enrollmentStatus_u0",
"__KEY_resourceList",
"__FK_resourceList",
(SELECT
"id",
"name",
"email",
"firstName",
"lastName",
"birthday",
"gender",
"__KEY_client",
"__FK_client",
(SELECT
"number",
"type",
"__FK_phone"
FROM "phone" FK "__FK_phone")
FROM "client" PK "__KEY_client" FK "__FK_client"),
(SELECT
"name" AS "name_u0",
"nationality",
"birthday" AS "birthday_u0",
"occupation",
"firstName" AS "firstName_u0",
"lastName" AS "lastName_u0",
"email" AS "email_u0",
"__FK_student"
FROM "student" FK "__FK_student"),
(SELECT
"id" AS "id_u0",
"name" AS "name_u1",
"email" AS "email_u1",
"iconUri",
"__FK_seller"
FROM "seller" FK "__FK_seller"),
(SELECT
"id" AS "id_u1",
"name" AS "name_u2",
"__FK_distributor_u0"
FROM "distributor" FK "__FK_distributor_u0"),
(SELECT
"departureDate",
"destination",
"interest",
"budget",
"channel" AS "channel_u0",
"comments",
"dateCreated",
"reporter",
"__FK_lead"
FROM "lead" FK "__FK_lead"),
(SELECT
"id" AS "id_u2",
"name" AS "name_u3",
"__FK_customStatus"
FROM "customStatus" FK "__FK_customStatus"),
(SELECT
"id" AS "id_u3",
"start",
"__FK_saleOrder"
FROM "saleOrder" FK "__FK_saleOrder"),
(SELECT
"id" AS "id_u4",
"name" AS "name_u4",
"__FK_saleGroup"
FROM "saleGroup" FK "__FK_saleGroup")
FROM "resourceList" PK "__KEY_resourceList" FK "__FK_resourceList")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (Url "$(vURL)");

[client.sale]:
LOAD [id] as id.sale,
[name] as name.sale,
[email] as email.sale,
[firstName] as [firstName.sale],
[lastName] as [lastName.sale],
[birthday] as [birthday.sale],
[gender] as [gender.sale],
[__KEY_client] as [__KEY_client.sale],
[__FK_client] AS [__KEY_resourceList.sale]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_client]);

store [client.sale] into [lib://QVD/client.sale.qvd] (qvd);
drop table [client.sale];

[student.sale]:
LOAD [name_u0] as [name_u0.sale],
[nationality] as [nationality.sale],
[birthday_u0] as [birthday_u0.sale],
[occupation] as [occupation.sale],
[firstName_u0] as [firstName_u0.sale],
[lastName_u0] as [lastName_u0.sale],
[email_u0] as [email_u0.sale],
[__FK_student] AS [__KEY_resourceList.sale]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_student]);

store [student.sale] into [lib://QVD/student.sale.qvd] (qvd);
drop table [student.sale];

[seller.sale]:
LOAD [id_u0] as [id_u0.sale],
[name_u1] as [name_u1.sale],
[email_u1] as [email_u1.sale],
[iconUri] as [iconUri.sale],
[__FK_seller] AS [__KEY_resourceList.sale]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_seller]);

store [seller.sale] into [lib://QVD/seller.sale.qvd] (qvd);
drop table [seller.sale];

[distributor_u0.sale]:
LOAD [id_u1] as [id_u1.sale],
[name_u2] as [name_u2.sale],
[__FK_distributor_u0] AS [__KEY_resourceList.sale]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_distributor_u0]);

store [distributor_u0.sale] into [lib://QVD/distributor_u0.sale.qvd] (qvd);
drop table [distributor_u0.sale];

[lead.sale]:
LOAD [departureDate] as [departureDate.sale],
[destination] as [destination.sale],
[interest] as [interest.sale],
[budget] as [budget.sale],
[channel_u0] as [channel_u0.sale],
[comments] as [comments.sale],
[dateCreated] as [dateCreated.sale],
[reporter] as [reporter.sale],
[__FK_lead] AS [__KEY_resourceList.sale]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_lead]);

store [lead.sale] into [lib://QVD/lead.sale.qvd] (qvd);
drop table [lead.sale];

[customStatus.sale]:
LOAD [id_u2] as [id_u2.sale],
[name_u3] as [name_u3.sale],
[__FK_customStatus] AS [__KEY_resourceList.sale]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_customStatus]);

store [customStatus.sale] into [lib://QVD/customStatus.sale.qvd] (qvd);
drop table [customStatus.sale];

[saleOrder.sale]:
LOAD [id_u3] as [id_u3.sale],
[start] as [start.sale],
[__FK_saleOrder] AS [__KEY_resourceList.sale]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_saleOrder]);

store [saleOrder.sale] into [lib://QVD/saleOrder.sale.qvd] (qvd);
drop table [saleOrder.sale];

[saleGroup.sale]:
LOAD [id_u5] as [id_u5.sale],
[name_u5] as [name_u5.sale],
[__FK_saleGroup] AS [__KEY_resourceList.sale]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_saleGroup]);

store [saleGroup.sale] into [lib://QVD/saleGroup.sale.qvd] (qvd);
drop table [saleGroup.sale];

[resourceList.sale]:
LOAD [id_u4] as [id_u4.sale],
[version] as [version.sale],
[pid] as [pid.sale],
[externalId] as [externalId.sale],
[name_u4] as [name_u4.sale],
[status_u0] as [status_u0.sale],
[courseType_u0] as [courseType_u0.sale],
[dateCreated_u0] as [dateCreated_u0.sale],
[lastUpdated] as [lastUpdated.sale],
[referrer_u0] as [referrer_u0.sale],
[interestLevel_u0] as [interestLevel_u0.sale],
[campaign] as [campaign.sale],
[formURL] as [formURL.sale],
[customStatus_u0] as [customStatus_u0.sale],
[saleGroup_u0] as [saleGroup_u0.sale],
[isEnabled_u0] as [isEnabled_u0.sale],
[manager_u0] as [manager_u0.sale],
[discardReason] as [discardReason.sale],
[enrollmentFieldApproved] as [enrollmentFieldApproved.sale],
[enrollmentFieldCount] as [enrollmentFieldCount.sale],
[paymentDueDate] as [paymentDueDate.sale],
[paymentStatus_u0] as [paymentStatus_u0.sale],
[enrollmentStatus_u0] as [enrollmentStatus_u0.sale],
[__KEY_resourceList] as [__KEY_resourceList.sale],
[__FK_resourceList] AS [__KEY_root.sale]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_resourceList]);

store [resourceList.sale] into [lib://QVD/resourceList.sale.qvd] (qvd);
drop table [resourceList.sale];

DROP TABLE RestConnectorMasterTable;

Hi Experts,

We have the production server with actual RAM of 64 GB.

However, the governance dashboard shows the Maximum RAM usage as 79 GB on a day and for an hour.

Could someone please explain what this means?

Thanks in advance.