Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ateafilar
New Contributor III

D and F values in Status bar

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

Tags (1)
4 Replies
Not applicable

Re: D and F values in Status bar

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

D: 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*

MVP
MVP

Re: D and F values in Status bar

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.

Not applicable

Re: D and F values in Status bar

you are right... I tested it with  "Select A1", not with "Select A3" ;-)

ateafilar
New Contributor III

Re: D and F values in Status bar

Thanks for your answers!

Community Browser