Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

Re: How to Count # of Row accessed ?

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.

10 Replies
paulyeo11
Valued Contributor II

Re: How to Count # of Row accessed ?

my qvw

Re: How to Count # of Row accessed ?

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
Valued Contributor II

Re: How to Count # of Row accessed ?

Hi Sunny

Any idea where can I locate the unique identifier .

Paul

Sent from my iPhone

phaneendra_kunc
Valued Contributor III

Re: How to Count # of Row accessed ?

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
Valued Contributor II

Re: How to Count # of Row accessed ?

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

Re: How to Count # of Row accessed  ?

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

paulyeo11
Valued Contributor II

Re: How to Count # of Row accessed ?

Hi Pha

Thank you , I manage to get what you said.

Paul

Sent from my iPhone

paulyeo11
Valued Contributor II

Re: How to Count # of Row accessed ?

Hi Sunny

Basically i create :-

'1' as count_raw,

and it work fine.

Thank you

Paul

vishsaggi
Esteemed Contributor III

Re: How to Count # of Row accessed ?

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.

Community Browser