topic Re: Using Variable for complete Set Analysis without error in QlikView

Using Variable for complete Set Analysis without error

richters — Wed, 23 Sep 2015 08:58:07 GMT

Hi all,

currently I am working on a problem which a lot of people might have:

My application includes a lot of different filters for the time-dimension (Year,Quarter,Month, Week, Day, Weekday, ...).

For a year-to-date - analysis I am doing sth. like:

Sum({<Date={'>=$(vMaxDateYearBeginning)<=$(vMaxDate)'}>} Income)

My problem now is:

If users select a year (e.g. 2015), the year-to-date kpi for maxYear-1 is null because in my set analysis I have to add all the time-filters as follows:

Year=,Quarter=, ...

As these filters might get more in future, I want to create a variable called vSetAnalysisYTD, vSetAnalysisYTDLastYear,... in order to change the variable later and not every formula.

But when I use these variables in a formula, an issue is recognized by Qlikview because it looks like:

Sum({<$(vSetAnalysisYTD)>} Income)

Is there an easy way to tell Qlikview that this is a possible way (as this formula works)?

Thanks for any idea!

Re: Using Variable for complete Set Analysis without error

Gysbert_Wassenaar — Wed, 23 Sep 2015 09:28:11 GMT

I'm afraid I don't understand the problem. Can you post a small qlikview document that demonstrates the problem?

Re: Using Variable for complete Set Analysis without error

swuehl — Wed, 23 Sep 2015 09:32:50 GMT

The syntax checker does not expand variables and check the resulting code, so it might and will e.g. use the red squiggles to denote a problem where in fact there isn't one. I don't know a way to get around this.

Please read also

SR11 Error Handling Changes | Qlikview Cookbook

Re: Using Variable for complete Set Analysis without error

richters — Wed, 23 Sep 2015 09:55:40 GMT

Hi,

here is a very simple application. The editor in the textbox shows a mistake where actually there is non. Is there any solution (create the variable on another way,...)?

Problem is that I am not really able to check complicated formulas if I write them like this.

Re: Using Variable for complete Set Analysis without error

Gysbert_Wassenaar — Wed, 23 Sep 2015 10:06:50 GMT

Ah, that. Well, Stefan answered your question above. The syntax editor doesn't resolve the expansion of the variables. That's often not possible since the variables will only get 'real' values at run time.

Re: Using Variable for complete Set Analysis without error

richters — Wed, 23 Sep 2015 10:10:48 GMT

No, the only problem is to check long formulas if they are really incorrect. Any solution for this?

Re: Using Variable for complete Set Analysis without error

Gysbert_Wassenaar — Wed, 23 Sep 2015 10:23:26 GMT

Test, test and test. First hardcode your set modifiers and test your set analysis expressions. Then use variables with hardcoded variables and test your expressions. Then test the expressions in your variables to make sure the variables with get the correct values. As said, the syntax checker cannot resolve dollar expension of the variables.

Re: Using Variable for complete Set Analysis without error

richters — Wed, 23 Sep 2015 10:48:54 GMT

That's what I expected and "feared". Thanks!