topic Re: How to Count # of Row accessed ? in QlikView

How to Count # of Row accessed ?

paulyeo11 — Sun, 07 Aug 2016 02:12:33 GMT

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

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

Paul

Re: How to Count # of Row accessed ?

paulyeo11 — Sun, 07 Aug 2016 02:13:20 GMT

my qvw

Re: How to Count # of Row accessed ?

sunny_talwar — Sun, 07 Aug 2016 05:03:34 GMT

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.

Re: How to Count # of Row accessed ?

paulyeo11 — Sun, 07 Aug 2016 06:11:08 GMT

Hi Sunny

Any idea where can I locate the unique identifier .

Paul

Sent from my iPhone

Re: How to Count # of Row accessed ?

phaneendra_kunc — Sun, 07 Aug 2016 06:57:56 GMT

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.

Re: How to Count # of Row accessed ?

paulyeo11 — Sun, 07 Aug 2016 08:23:08 GMT

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

Re: How to Count # of Row accessed ?

phaneendra_kunc — Sun, 07 Aug 2016 08:36:19 GMT

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.

Re: How to Count # of Row accessed ?

paulyeo11 — Sun, 07 Aug 2016 09:23:08 GMT

Hi Pha

Thank you , I manage to get what you said.

Paul

Sent from my iPhone

Re: How to Count # of Row accessed ?

paulyeo11 — Mon, 08 Aug 2016 08:34:23 GMT

Hi Sunny

Basically i create :-

'1' as count_raw,

and it work fine.

Thank you

Paul

Re: How to Count # of Row accessed ?

vishsaggi — Wed, 10 Aug 2016 03:11:03 GMT

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.

Re: How to Count # of Row accessed ?

phaneendra_kunc — Wed, 10 Aug 2016 04:00:40 GMT

$Rows will give 0 since it is pulling from Direct Discovery table in this case. Also $Rows will be a static number where it gets generated at the time of script load and doesn't change based on selection.