Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

How to Count # of Row accessed ?

Hi All

I just saw the live demo of Jethro + Qlik available at: Qlik Sense.

http://jethrodata.qlik.com/sense/app/717577cf-e7d6-4a0e-82c5-cd6d1913977f?_ga=1.69513811.215691761.1...

count row.png

May i know what is the expression for the above mentioned ?

Paul

1 Solution

Accepted Solutions
Highlighted

I cannot look into the expression, but from what I understand, it can be the count of unique identifier in your fact table. Unique identifier can never be null and will thus give you the visibility into the # of rows currently used based on your current selections.

View solution in original post

10 Replies
Highlighted
Master
Master

my qvw

Highlighted

I cannot look into the expression, but from what I understand, it can be the count of unique identifier in your fact table. Unique identifier can never be null and will thus give you the visibility into the # of rows currently used based on your current selections.

View solution in original post

Highlighted
Master
Master

Hi Sunny

Any idea where can I locate the unique identifier .

Paul

Sent from my iPhone

Highlighted
Partner
Partner

Hi Paul Yeo...

I believe it is Count(customer_sk) if i am not wrong. As Sunny mentioned it is unique identifier for each row in fact.

One trick i would say is to replace "Analysis" with  "Edit" in sense URL's where u wont find EDIT button. Try accessing below link and on left you can get to library items and clicking on any measure will show the expression in tiny little window.

http://jethrodata.qlik.com/sense/app/717577cf-e7d6-4a0e-82c5-cd6d1913977f/sheet/HbErK/state/edit

Are you using Jethro? i have done a recent deployment with 9billion rows of data, and it is blazing fast.

Highlighted
Master
Master

Hi Pha

Thank you for your shring.

I am unable to go to edit mode of the cloud QVF , But then I can access the hub , to see other App.

In QS to get edit mode , I need to select the table or chart , but the link give by you or me unable to select the object.

For the field name customer_sk , I believe is from QS QVF link you provide. What it the expression for count # of row using customer_sk ?

I am not using Jethro , I just recently read and participate forum blog discussion on big data and find the demo.

Paul

Sent from my iPhone

Highlighted
Partner
Partner

As i mentioned it is "count(customer_sk)" for "Rows accessed.

in this case of EDIT mode you wont have access to object in the middle of the screen. I said to look for library on left collapsible panel, where you see "chain link" symbol.

But any ways, what are you trying to get to?  In here Qlik is using Jethro with Direct Data discovery and they are all same old qlikview/qlik sense expressions.

Qonnections16 Demo   Sheets   Qlik Sense.png

Highlighted
Master
Master

Hi Pha

Thank you , I manage to get what you said.

Paul

Sent from my iPhone

Highlighted
Master
Master

Hi Sunny

Basically i create :-

'1' as count_raw,

and it work fine.

Thank you

Paul

Highlighted
Champion III
Champion III

I know it is not pretty new post, just wondering cant we use system fields here ?

Like for rows accessed : = Sum({1} $Rows)

Please correct me...

Thanks,
V.