Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ishanbansal1204
Contributor III
Contributor III

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

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);

 

 

Labels (2)
1 Solution

Accepted Solutions
PrashantSangle

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

3 Replies
Anil_Babu_Samineni

Can you do resident instead direct load?
Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
PrashantSangle

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
Contributor III
Contributor III
Author

Hi,

Its given me Invalid Expressions Error in Resident code.