topic Re: Creating Criteria for Variables without set analysis (no function) in QlikView

Creating Criteria for Variables without set analysis (no function)

lucasdavis500 — Wed, 25 Nov 2020 16:16:04 GMT

How can I retrieve values based on something similar to set analysis for variables I have in my data?

Example:

I have text objects I use in my dashboard to show the user the most current data or data based on their selection.

Here's one of my text boxes:

='Furnishings for ' & Month(NOW() - 1 ) & ' ' & Year & ' ' & ':'

Returns: Furnishings for Oct 2016:

Below this I have another text object that is simply my variable

=Furnishings

I want "Furnishings" to resemble something similar to the first text box, and return the value for that month, if I could do =({<Month = {'Month(NOW() - 1)'}>}Furnishings)

Then the above would be something similar to how it could be done in Set Analysis, except I don't have an actual FUNCTION in order to use set analysis, just a variable.....

Re: Creating Criteria for Variables without set analysis (no function)

Anil_Babu_Samineni — Tue, 01 Nov 2016 22:00:02 GMT

Do you mean this

='Furnishings for ' & Only({$<Month = {'$(=Month(NOW() - 1))'}>}Furnishings) & ' ' & Max(Year) & ' ' & ':'

Re: Creating Criteria for Variables without set analysis (no function)

sunny_talwar — Wed, 02 Nov 2016 02:07:53 GMT

Are you looking for this may be?

='Furnishings for ' & Month(NOW() - 1 ) & ' ' & Year & ' ' & ':' & Only({<Month = {"$(=Month(Today() - 1))"}>} Furnishings)

Re: Creating Criteria for Variables without set analysis (no function)

lucasdavis500 — Wed, 02 Nov 2016 13:12:03 GMT

I'm interested in this piece, =Only({<Month = {"$(=Month(Today() - 1))"}>} Furnishings), but, for some reason, qlikview doesn't like when I use double quotes ("). I've seen set analysis used with double quotes on this page before, and when i try to do the same for my set analysis, it treats the entire string within the quotes as a variable (it turns red)... is this normal?

Re: Creating Criteria for Variables without set analysis (no function)

lucasdavis500 — Wed, 02 Nov 2016 13:13:59 GMT

+1 for both of you, I believe Sunny's is more resource efficient because of the Today function vs NOW

Re: Creating Criteria for Variables without set analysis (no function)

lucasdavis500 — Wed, 02 Nov 2016 13:14:43 GMT

Correction, it worked, I just had a small syntax error but my set analysis still turns red like i'm trying to reference a variable