Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

System Fields filtering cannot be undone

plexpro52
Contributor

System Fields filtering cannot be undone

According to Qlik Sense documentation at http://help.qlik.com/sense/en-US/online/#../Subsystems/Hub/Content/Scripting/SystemFields.htm%3FTocP..., I can create filter panes and tables to display the system fields listed there (as well as below).

I did this.  In one table visualization I put $Table, $Rows, and $Fields.  In another table visualization I put $Field and $FieldNo.

I found that if I select a specific value of, say, $Table, the filter does not appear in the Selections bar at the top (it continues to show "No selections applied").  Nor can the filtering be undone, except by refreshing the web page.  In Qlik Sense Desktop, not even refreshing the page undoes the selection, nor does closing and reopening the app, nor does closing and restarting Qlik Sense Desktop.  The filtering becomes a permanent feature of the app!!

Also, if I make a tentative selection of a table name value, unselected and excluded values in associated fields in the $Field-$FieldNo table do not display.  If I approve the selection, all the unselected values in the $Table-$Rows-$Fields table disappear as well.

System fields

In addition to the fields extracted from the data source, system fields are also produced by Qlik Sense. These all begin with "$" and can be displayed like ordinary fields in a visualization, such as a filter pane or a table. System fields are typically created during script execution, and are primarily used as an aid in app design.

System fields are not included in field lists in the assets panel or the Expression editor. If you want to use a system field, you need to reference it by typing it manually.

Example: =$Field

Available system fields

The following system fields are available:

$Table Displays all internal tables loaded by the script.
$Field Displays the fields that are read from the tables.
$Fields Represent the number of fields in different tables.
$FieldNo Displays the position of the fields in the tables.
$Rows Displays the number of rows in the tables.
$Info Displays names of info tables, if they have been included in the app.
Comments
Not applicable

This also happened to me: "The filtering becomes a permanent feature of the app!!"

I threw away the app and made another one with a table visualization that I called "DO NOT FILTER!!! Only export to XLSX..."

I think, having an easy and bug free access to the app meta data is a basic right for each developer...

plexpro52
Contributor

Hello Arthur,

So, this still happens?  What version are you using?

Regards,

René

plexpro52
Contributor

Five weeks after my original post came this exchange with support personnel; I was quoting an earlier exchange between Support and myself and making further comments.  This behavior appears to be unchanged in version 2.2.4.  Perhaps it will have been addressed in 3.0; we'll see shortly.

Support >> ...this behavior is as they intended and similar to the functionality in QlikView.


myself >> I found that if I select a specific value of, say, $Table, the filter does not appear in the Selections bar at the top (it continues to show "No selections applied").  Nor can the filtering be undone, except by refreshing the web page.  In Qlik Sense Desktop, not even refreshing the page undoes the selection, nor does closing and reopening the app, nor does closing and restarting Qlik Sense Desktop.  The filtering becomes a permanent feature of the app!!


The behavior is inconsistent between the Desktop and Server versions.  How can it be "intended" as is?


myself >> Also, if I make a tentative selection of a table name value, unselected and excluded values in associated fields in the $Field-$FieldNo table do not display.  If I approve the selection, all the unselected values in the $Table-$Rows-$Fields table disappear as well.

They intend for unselected and excluded values in a filter pane to disappear?

Not applicable

Hi René,

on 2.2.4, let's see what 3.0 has to offer

plexpro52
Contributor

Hello Arthur,

I have installed 3.0 desktop, and found that refreshing the page, as well as closing and reopening the app, restores selections to everything.  That is good.

The other issue of selections not appearing in the Selections bar continues.  Also, if I make a tentative selection of a table name value, unselected and excluded values in associated fields in the $Field-$FieldNo table do not display.  However, I realized that I can create Filter Panes for specific fields to work around these shortcomings.

Version history
Revision #:
1 of 1
Last update:
‎05-01-2015 12:38 PM
Updated by: