Banner table

[Anonymous]

Hi community,

Is it possible in QV create table where 2 variable one below other.

Please see below my image

Thanks,

[Anonymous]

If you can verify which variable is aligned to which of the second dimension values, then i suggest you create another field in the same table using the same logic and then its as simple as adding that field to the pivot table.

I mean.. if you know only... "aaaaa, ssss, dddd, fgfg" should have Var1, then you can use the same logic to add that variable value as a field value during the script load.

[bbi_mba_76]

Hi,

I don't understand so much, but maybe you could try with the valuelist function.

[rbecher]

What is the purpose of Var1/Var2? To group the second dimension?

- Ralf

[Anonymous]

It's 2 different variable.

I just want to combine 2 pivot table, because they use the same dimension MonthYear.

[Clever_Anjos]

Try to add

valuelist('Var1','Var2') as your dimension

At expression level you have to test which value

if(

   valuelist('Var1','Var2') = 'Var1', something, anotherexpression

)

[Anonymous]

Each variable has own tags.

Var1 :aaa, bbb, ccc

Var2: www, eee, rrrr

It didn't work

[Clever_Anjos]

Are they variables or fields?

I don´t know how a variable can have more than one value

[Anonymous]

Sorry fields

[Clever_Anjos]

Maybe I´m missing something.

Is this what you want?