Solved: Count Function in Qlik sense when XML Webfile (Sha... - Qlik Community

ishanbansal1204 · ‎2018-11-20

Hi All,

I am pulling the project related KPIs from the Sharepoint folder and I am facing difficulties in using the count function.

I am not sure if we can use count function while loading XML Date. Details below

LOAD
floor(ID) AS ID,
COUNT(floor(ID)) AS COUNT
FROM [lib://Analytics]
(XmlSimple, table is [xml/data/row])
GROUP BY floor(ID);

PrashantSangle · ‎2018-11-20

Hi,

Use Resident Load

temp:
LOAD
ID AS ID
FROM [lib://Analytics]
(XmlSimple, table is [xml/data/row])
;

Noconcatenate
Final:
Load floor(ID) as ID,
Count(floor(ID)) as COUNT
Resident temp;

drop table temp;

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

Anil_Babu_Samineni · ‎2018-11-20

Can you do resident instead direct load?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

PrashantSangle · ‎2018-11-20

Hi,

Use Resident Load

temp:
LOAD
ID AS ID
FROM [lib://Analytics]
(XmlSimple, table is [xml/data/row])
;

Noconcatenate
Final:
Load floor(ID) as ID,
Count(floor(ID)) as COUNT
Resident temp;

drop table temp;

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ishanbansal1204 · ‎2018-11-20

Hi,

Its given me Invalid Expressions Error in Resident code.

Count Function in Qlik sense when XML Webfile (Sharepoint) is Involved.

Qlik Sense

Sharepoint