topic Re: Dimension value in set expression in QlikView

Dimension value in set expression

Anonymous — Fri, 31 Jul 2015 06:43:51 GMT

Is there a way to get the value of dimension to be used in set analysis without using if statement?

Re: Dimension value in set expression

swuehl — Fri, 31 Jul 2015 07:00:41 GMT

No, a set expression will be evaluated once per chart, not per dimension line, so there is no chart dimension awareness.

Re: Dimension value in set expression

jonathandienst — Fri, 31 Jul 2015 07:06:35 GMT

If you are planning to use a set expression in a chart or table for a row-by-row comparison, then that will not work. Set expressions are evaluated once for the chart/table and have no knowledge of the dimensions.

You can use a sum(if()) structure to access the dimension values on a row by row basis if your data set is not too big. This type of expression can perform poorly on large data sets. In this case, it is better to add flag fields in the load expression and use these flag fields in a set analysis expression.

Re: Dimension value in set expression

Anonymous — Fri, 31 Jul 2015 07:36:12 GMT

This is what I was showing: The user was selecting a month Year and following measure was shown:

count({<[Account Start Date]={"<$(vCurrentMonthStartABC)"},[Account End Date]={">=$(vCurrentMonthStartABC)"},[Account BU]={'ETS'}>})

Now, they want to see this for all month years irrespective of selection.

So, I would need to know the MonthYear (from dimension) so that I can calculate the month start date to use it in the above expression. Is there a way to do this?

Re: Dimension value in set expression

JuanManuelLopezFelizzola — Mon, 06 Jul 2020 23:10:15 GMT

You could use a pick match combination in conjunction with the Only(Dimension)