How to Count # of Row accessed ?

[paulyeo11]

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...

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

Paul

[paulyeo11]

my qvw

[sunny_talwar · Accepted solution]

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.

[paulyeo11]

Hi Sunny

Any idea where can I locate the unique identifier .

Paul

Sent from my iPhone

[phaneendra_kunc]

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.

[paulyeo11]

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

[phaneendra_kunc]

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.

[paulyeo11]

Hi Pha

Thank you , I manage to get what you said.

Paul

Sent from my iPhone

[paulyeo11]

Hi Sunny

Basically i create :-

'1' as count_raw,

and it work fine.

Thank you

Paul

[vishsaggi]

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.