Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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*
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.
you are right... I tested it with "Select A1", not with "Select A3" 😉
Thanks for your answers!