topic Setting result of IF statement to dimension in App Development

Setting result of IF statement to dimension

Evan0211 — Tue, 21 Mar 2023 12:08:51 GMT

New to Qlik and have a question on storing the outputs of an if statement to a custom dimension to be used in charts.

Basically, what I want to do is something like this:

if([date] > Today, 'Future', 'Past')

Then be able to say if [CustomDimension] = 'Future', do something (count the number of records returned, custom coloring, etc)

How do I save the if statements value to a custom dimension to use elsewhere without having to reuse the if statement?

Re: Setting result of IF statement to dimension

Or — Tue, 21 Mar 2023 12:26:36 GMT

You would typically add this as a field in your load script, making it easily reusable across the entire app.

Re: Setting result of IF statement to dimension

Evan0211 — Tue, 21 Mar 2023 12:41:38 GMT

I did the following:

SET _DateCheck = if([date] > Today, 'Future', 'Past');

And then I set a pie chart to _DateCheck and did the measure as a Count([ID]).

Now, I want to do a custom color on the pie chart like this:

Custom Color Expression: If(_DateCheck = 'Future', Blue(), Red())

but it is changing the entire pie chart to Red()

I have also tried

If(Pick(_DateCheck , 'Future'), Blue(), Red()) but it still colors the entire pie chart red instead of just the past slice.

Re: Setting result of IF statement to dimension

Or — Tue, 21 Mar 2023 12:50:54 GMT

Set creates a variable, not a field, and it does not evaluate the expression (you would need Let for that). You also incorrectly used Today instead of Today().

You would typically do this as a field in the load statement, e.g.

Load Date, if(Date > Today(), 'Future','Past') as isFuture, SomeOtherField

From SomeTable;