Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
why count({<Day={"$(=Max(Day))"}>} Day) is not equal to write:
count({<Day={"=$(=Max(Day))"}>} Day)?
I get different returns. But according to Syntax I got no errors. I browsed all the Qlik Help Site about Dollar Expansion variants. The additional '=' was never mentioned in the examples.
Thanks to your help!
I don't know, if semantically correct.
but if you just look at the syntax, the reason for having two results is that the second one doesn't take the value in {} , no error but simply ignored.
look at these three examples
the first with
count({<Day={"$(=Max(Day))"}>} Day)
the second with
count({<Day={"=$(=Max(Day))"}>} Day)
and the third one without analysis set
count( Day)
and you notice that for the second one, it's like the set analysis {} doesn't exist.
{<Day={"$(=Max(Day))"}
- For this, as you rightly understand the maximum Day, i.e. one day out of the entire set of days in the scope would be considered.
{<Day={"=$(=Max(Day))"}>}
- For this, as you would usually don't want the maximum Day for every individual days would be considered. That is effectively all the days would be taken into consideration. And that is because, when your set analysis search string begins with an '=', the qlik engine works in the line of advanced search for the dimension.
That is how they are different.
I don't know, if semantically correct.
but if you just look at the syntax, the reason for having two results is that the second one doesn't take the value in {} , no error but simply ignored.
look at these three examples
the first with
count({<Day={"$(=Max(Day))"}>} Day)
the second with
count({<Day={"=$(=Max(Day))"}>} Day)
and the third one without analysis set
count( Day)
and you notice that for the second one, it's like the set analysis {} doesn't exist.
{<Day={"$(=Max(Day))"}
- For this, as you rightly understand the maximum Day, i.e. one day out of the entire set of days in the scope would be considered.
{<Day={"=$(=Max(Day))"}>}
- For this, as you would usually don't want the maximum Day for every individual days would be considered. That is effectively all the days would be taken into consideration. And that is because, when your set analysis search string begins with an '=', the qlik engine works in the line of advanced search for the dimension.
That is how they are different.