Qliksense Dynamic Data Filtering

[tvsr111]

Hi,

we have a Star schema model where the Fact table is SCD type 2 which holds balances by the dates.

Fact table has 2 columns Valid_From_Date and Valid_To_Date which should be used to select data for a specific date

When User opens an app, he has to select a date first and based on that selected date, data should be populated.

please suggest how to implement this requirement

[Oliver_F]

Hi,

I just double checked. The feature is available in tables too.

If you do have measures, than you should be able to just apply the Set-Analysis statement from above to all of them and your table will be reduced to the data rows you are looking for.

If you want to use master items you will have to actually *filter* your data. You could use a dynamic dimension:

=if(Valid_from < Date and Valid_to > Date, Key,null())

This in combination with the subpress null might work, but performance of dynamic dimensions is definetly not as good.

As said earlier, you will somehow have to filter you data and might want to consider using an extension then?

[tvsr111]

Hi,

yes ofcourse we would like to see if that extension can help

Can you show a sample or demo of how that extension works

And where and how we get the extension (like source , pricing, validity, etc)

[tvsr111]

"I just double checked. The feature is available in tables too." 

Table has an option "Include null values" under Addons --> Data handling

but I cant find the "Include null values" option on table visualization   (unless I am not looking at right area)

[Oliver_F]

Hi,

I attached

- A screenshot that shows the hide null-values option in the table.

- A video that shows how MENUBAR can help in your use case. (Please note that, this is only a very special use case and our extension has way more features and possibilities - https://www.truechart.com/software/menubar/ ) - If you are interested in using this extension, feel free to write me a private message so we can arrange a live demo.