Restrict Table based on Time Dimensions Dynamically

zabiullahsyed — Sat, 18 Jan 2020 17:41:04 GMT

Dear Experts,

I am new to Qliksense. I have an App with different sheets. The data is shown in table.

I would want to have a dynamic selection and restriction of all measures in table for time dimensions like YTD, Full year.
These time dimensions are defined in a script.

I am not able to link these time dimensions to the measures.

I have created a master item to have these time dimensions selection in sheet but cannot link the measures.

Can anyone advice how I can achieve so that the measures in the table update based on the time dimension selection.

Thank you.

Re: Restrict Table based on Time Dimensions Dynamically

jheasley — Sun, 19 Jan 2020 13:27:21 GMT

you will need to make a field with a common name in both tables. for example, if your fact table has [SalesDate] and your master calendar with the YTD flag has [Date], you could add [Date] as [SalesDate] to the script for the master calendar, which would then create the link.

topic Restrict Table based on Time Dimensions Dynamically in App Development

Restrict Table based on Time Dimensions Dynamically

Re: Restrict Table based on Time Dimensions Dynamically