topic Re: Dynamically switching which field is being used in a filter in App Development

Dynamically switching which field is being used in a filter

mhassinger — Thu, 16 Jun 2022 00:00:26 GMT

Wondering if this is possible.

I've got a little data island with two values - Monthly and Weekly, and two fields in the fact table called Month-Year and Week-Year.

Depending on what the user selects (Monthly or Weekly), I'd like a filter on the page to switch between displaying values for the Month-Year field or the Week-Year field.

I've tried creating a variable that returns the string 'Month-Year' and 'Week-Year' and using that variable in the filter's dimension definition, but that doesn't work. Any ideas?

Re: Dynamically switching which field is being used in a filter

rwunderlich — Thu, 16 Jun 2022 03:35:06 GMT

It should work if you wrap your Dim field reference in a $() like

=$(=MinString(Dim))

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Dynamically switching which field is being used in a filter

Vegar — Thu, 16 Jun 2022 06:17:20 GMT

To do Rob's solution I think you need to rename or associate your 'Monthly' and 'Weekly' values to 'Month-Year' and 'Week-Year' .

Let's say you have this:

GUI:

LOAD * INLINE [

Period, Dim

Monthly, Month-Year

Weekly,Week-Year];

ApplicationData:

Load * From TransaktionData;

];

Then you should be able to use Rob's suggested technique. Making selections in [Period] and displaying the field name found in the associated [Dim] field.

=[$(=MinString(Dim))]

Re: Dynamically switching which field is being used in a filter

mhassinger — Thu, 16 Jun 2022 14:58:58 GMT

Thank you both for the input. I must still be missing something because it doesn't work.

Here's my inline table load for the data island.

TimeSelect:
Load * Inline
[
Monthly or Weekly, Dim
Monthly, Month-Year
Weekly, Week-Year
];

Here is my variable definition for vTimeFrame.

if(Only([Monthly or Weekly]) = 'Monthly', 'Month-Year','Week-Year')

That seems to work fine because $(vTimeFrame) in a text & Image object evaluates it correctly to one of the two strings.

Finally in my filter pane dimension field expression I have what Rob proposed:

=$(=MinString(vTimeFrame))

I must just be misunderstanding something.

Re: Dynamically switching which field is being used in a filter

Vegar — Thu, 16 Jun 2022 15:03:16 GMT

Try using this as a dimension.

[$(vTimeFrame)]

Re: Dynamically switching which field is being used in a filter

mhassinger — Thu, 16 Jun 2022 17:09:23 GMT

No go. It actually gives me a invalid dimension error when I do that. With '=$(=MinString(vTimeFrame))' the filter pane was empty but it didn't give an error.

Re: Dynamically switching which field is being used in a filter

rwunderlich — Fri, 17 Jun 2022 17:57:23 GMT

A couple of thoughts. Since you have already created the string in the variable, you wouldn't use MinString. But you don't really need the variable at all. Just go with using the Dim field.

=$(=MaxString(Dim))