topic Table with Quarter in QlikView

Table with Quarter

Sat, 20 Feb 2010 17:11:04 GMT

Hello,

Somebody can help me?

This is the problem:

I want to build a table (see table Quarter) in the file attached in which to see last quarter, the previus quarter and the same quarter of the previus year. If none selection are active I want to see last quarter (Gen-Mar 2010), the previus quarter (Ott-Doc 2009) and the same quarter of the previus year (Gen-Mar 2009).

If I select another quarter (ex: IdQuart=19) all is OK, but if I select the corresponding DescrQuart (ex: DescrQuart=2009-3), the value of the previus quarters in the table are 0.

WHY???

HOW CAN I DO???

If I try a set analysis like:

Sum( { 1<IDQuart={"$(=max(IdQuart))"}> } Sales)

I don't can to select another column like DescrType.

THANK ALL

Table with Quarter

Mon, 22 Feb 2010 10:07:49 GMT

Hi,

you should remove the selections of other fields. So suggest you to write this:

Sum(
{<
IdQuart={"$(=max(IdQuart)-4)"},
DescrQuart,
Year
>}
Sales)

In this case you will remove selections of fields - DescrQuart and Year.

Use this to calculate the previus quarter and the same quarter of the previus year.

Milda

Table with Quarter

Wed, 24 Feb 2010 15:21:37 GMT

Hi Milda,

Thank for your help.

I don't understand your solution (see table "Quarter - Milda" in the attached file).

If I select the field DescrQuart, I have always the columns with 0. Why?

Thank

Table with Quarter

Thu, 25 Feb 2010 08:05:25 GMT

Hi Sbuzi,

sorry but I don't understand your question. Because when I select something in DescrQuart, I get the result (numbers) in table "Quarter-Milda" (NOT 0).

Milda

Table with Quarter

Sat, 27 Feb 2010 17:23:54 GMT

Hi Milda,

thank for your help.

If you see the file attached, there is the sample in which if I select the field DescrQuart, the first two columns of the table "Quarter - Milda" are 0.

Thank All

Table with Quarter

stephencredmond — Sat, 27 Feb 2010 21:34:21 GMT

Hi,

You seem to have missed a step recommended earlier. You need to exclude the selections in the field from impacting your query:

Sum({<IdQuart={"$(=max(IdQuart)-4)"}, DescrQuart=>} Sales)

If you don't include the "DescrQuart=" part in your set then you will get 0 in the chart. Including it with just "=" and no set means "for all values" - i.e. it ignores selections on that field.

Stephen

Table with Quarter

Tue, 02 Mar 2010 16:53:40 GMT

Thank very much!

I was not careful.

Thank