Conditionally Clear selections

tvsr111 — Sat, 02 May 2020 18:55:20 GMT

* We have a Flying Table with Dates

* A star schema with Fact & Dimensions. Fact Table has 2 date columns as Valid_From_Date & Valid_To_Date

FlyingTable has not relation with Fact table model

craeted a variable: varDateSelected=coalesce(GetFieldSelections(DateValue),today())

Later I have create some Dimesions and Measures by referring to the Date selected on FlyingTable

for example:

LineofBusiness: if(varDateSelected>=Valid_From_Date and Valid_To_Date<=varDateSelected, [LineofBusiness], null())

Sales: if(varDateSelected>=Valid_From_Date and Valid_To_Date<=varDateSelected, [Sales], 0)

By doing so, the visualizations and data are working all fine.

But there is a problem when we make any selection by a Dimension value.

For example, if I select LineofBusiness dimension to a vlaue like 'Fleet'.... the visualization is changing based on varDateSelected+'Fleet'

for this one selction made on visualisation, on the Selections area in top, we see 3 selections based on Valid_From_Date & Valid_To_Date & LineofBusiness values

then when I undo the LineofBusiness from selections panel.... the other 2 selections on Valid_From_Date & Valid_To_Date stays on.
And that limits data to teh dates relevant to earlier selection only.

so basically what we want to, when all the manually made selection are cleared, I want to clear other implicit selections

or may be some code to run when ever any selctions are cleared... it should run and check how many selection do exist if the count>2, then we should able to clear all the selection

Not sure if we are asking tooo much from qliksense

topic Conditionally Clear selections in App Development

Conditionally Clear selections