topic Re: D and F values in Status bar in QlikView

D and F values in Status bar

Anonymous — Mon, 05 Nov 2012 10:00:03 GMT

Hi!

On the QlikView status bar, there are two different values of the number of rows in a table, D and F.

Can anyone explain the difference between those two values. I have an application with one single table, och want to find how the total number of rows in the table.

Found this in QV reference guide, but I didn't get it:

On the right side of the status bar, the number of distinct optional (or selected) values over the total number of distinct values in the active list box is presented, preceded by a D. Further to the right, preceded by an F, the frequency of the active field is presented, showing the number of records in the table where the field first occurs over the total number of records.

Thanks in advance!

Best regards,

Filip

Re: D and F values in Status bar

Mon, 05 Nov 2012 10:32:20 GMT

LOAD * INLINE

[F1, F2

A1, B1

A2, B2

A3, B3

A3, B4

A1, B1

A2, B2

A3, B3

A3, B4

];

8 Rows

F1 = 3 distinct values

F2 = 4 distinct values

😧 selected distinct values / total distinct values from your highlighted Listbox (value)

F: selected rows / total rows

example

select A3 in F1

Focus Listbox F1 -> D 1/3 F 4/8

(don´t change your selection)

Focus Listbox F2 -> D 1 2/4 F 4/8

Best regards

*Edit: remove typo error*

Re: D and F values in Status bar

swuehl — Mon, 05 Nov 2012 10:51:43 GMT

Nice explanation, only one remark (maybe it's just a typo):

>> Focus Listbox F2 -> D 1/4 F 4/8

I think you get D 2/4 returned, since the distinct possible values in F2 are B3 and B4.

Re: D and F values in Status bar

Mon, 05 Nov 2012 11:05:36 GMT

you are right... I tested it with "Select A1", not with "Select A3" 😉

Re: D and F values in Status bar

Anonymous — Mon, 05 Nov 2012 13:33:37 GMT

Thanks for your answers!