Dimensions and Expression - creating a simple Table

[#1]

Dear QV commuity,

today i have a (i think) basic question.

Of yourse our management is used to work in XLS and there the tables are always the same like this

                    JAN     FEB     MAR     APR ...

Country1       sales

Country2       sales

etc...             sales

So basically QV works with Expressions and Dimensions - in this case Months and Countries are bot Dimensions and i have to CHOOSE if i want to show them horizontal or vertical - but as you can see i need to choose INDIVIDUALLY to have one dimension horizontal and the other vertical.

Is thsi possible? seems so simple but i could not find

Thanx for your help

Seb

[its_anandrjs]

Hi,

Use Straight Table or Pivot Table for this type of requirement.

Regards,

Anand

[#3]

i am using a straight table - but then i can only choose if ALL dimension should go horizontal or not - this does not help seems like a bug - because the check mark is not applied only to the selected dimension...

[its_anandrjs]

Hi,

Write some thing like

=Sum(if(Months = 'Jan', Sales)) in the expression for the month if you are using straight table. Can you provide any sample file

Regards,

Anand

[#5]

hai,

pls see thebackend script for cross table

Regards,

chandu

[#6]

sorry i cannot open can you please provide screenshots of the Properties?

[its_anandrjs]

Hi,

Use this sample

Temp:

load Country,Months, num( Sales,'#.##') as Sales;

load * inline

[

Country,          Months,          Sales

Country1,          Jan,          44.09670183

Country1,          Feb,          85.15861071

Country1,          Mar,          109.4297193

Country1,          Apr,          35.21244308

Country1,          May,          39.93113584

Country2,          Jun,          33.03100126

Country2,          Jul,          62.78281869

Country2,          Aug,          102.2187705

Country2,          Sep,          89.04048974

Country3,          Oct,          108.4429708

Country3,          Nov,          87.25831891

Country3,          Dec,          106.8788417

Country3,          Jan,          44.29773026

Country3,          Feb,          78.90228828

];

or in Straight table

Dimension : Country

Expression : Sum(if(Months = 'Jan', Sales)), Sum(if(Months = 'Feb', Sales)).....

Let me know

HTH

Regards,

Anand

[#8]

i am really sorry but i still cannot see how this can work -

my fields are Months (dimension), Country (dimension) sum(sales) (expression.

now i create a VERY simple straight table like above and the result is either

Jan | Country1 | 423

Jan | Country2 | 342

Jan | Country3 | 324

Feb | Country1 | 231

...

or

JAN | JAN | JAN | JAN | JAN |

C1     C2     C3     C4

232     232     232     232

Both is not acceptable

[bharatkishore]

HI scdrawert,

Please Check the attached file. I hope this is the solution what you are looking for

[bharatkishore]

scdrawert,

We can use generic load concept and display in table box. Check the attached file.