topic Set analysis expression for year to month analysis in QlikView

Set analysis expression for year to month analysis

Mon, 02 May 2011 11:23:45 GMT

Hi,

I've a table with a year_and_month as a dimension and an amount as a measure. For my analysis, I have used a pivot chart.

I've put the year_and_month field on a list box. For my measure, in the pivot chart I've specified this set analysis expression:

sum({$<year_and_month = {"<=$(=$(vYearMonth))"}>} Amount).

When I select an unique value in year_and_month list box, I have the right result, thus the rows in pivot with year_and_month value equals to, fe, 201101, 201102, but when I select 201003 and 201102 I have 201001, 201002, 201003 and 201101, 201102, 201103 in the pivot, but the expected result for the 2011 year is 201101 and 201102 not 201103.

How can I solve this issue, please? Many thanks

Set analysis expression for year to month analysis

Anonymous — Mon, 02 May 2011 11:35:04 GMT

Can you upload your QV-file here?

Set analysis expression for year to month analysis

erichshiino — Mon, 02 May 2011 12:14:49 GMT

What is the expression in 'vYearMonth'? Which dimensions did you include in your chart?

Set analysis expression for year to month analysis

Mon, 02 May 2011 12:26:01 GMT

Hi, thanks.

Year_and_month is a dimension in the pivot chart and there is another dimension (fe employee code).

vYearMonth is a variable. This variable contains all the selected values for year_and_month.

Thanks

Set analysis expression for year to month analysis

erichshiino — Mon, 02 May 2011 12:34:47 GMT

You shouldn't use '<='. Try this:

sum({$<year_and_month = {"<$(=$(vYearMonth))"}>} Amount).

or you let me rewrite, please try:

sum({$<year_and_month = {"<$(=max (vYearMonth ) )"}>} Amount).

Set analysis expression for year to month analysis

Mon, 02 May 2011 13:04:02 GMT

Hi, Eric,

I've tried the sum({$<year_and_month = {"<$(=$(vYearMonth))"}>} Amount) expression, but unsuccessfully. Why do I need to change ...<=$... in ...<$...? I don't understand this passage.

The core of this issue is that I can select more one values for year_and_month and I must show for the specific selected year the months between january and the selected month.

In other terms, if I select year_and_month = 201003 and year_and_month = 201102 I must show on the pivot:

201001, 201002, 201003;
201101, 201102.

Thanks