topic Re: Banner table in QlikView

Banner table

Anonymous — Thu, 28 Nov 2013 16:46:05 GMT

Hi community,

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

Please see below my image

Thanks,

Re: Banner table

Anonymous — Thu, 28 Nov 2013 17:16:02 GMT

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.

Re: Banner table

bbi_mba_76 — Thu, 28 Nov 2013 17:17:06 GMT

Hi,

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

Re: Banner table

rbecher — Thu, 28 Nov 2013 17:33:25 GMT

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

- Ralf

Re: Banner table

Anonymous — Thu, 28 Nov 2013 18:01:23 GMT

It's 2 different variable.

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

Re: Banner table

Clever_Anjos — Thu, 28 Nov 2013 18:15:32 GMT

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

)

Re: Banner table

Anonymous — Thu, 28 Nov 2013 18:45:36 GMT

Each variable has own tags.

Var1 :aaa, bbb, ccc

Var2: www, eee, rrrr

It didn't work

Re: Banner table

Clever_Anjos — Thu, 28 Nov 2013 20:10:52 GMT

Are they variables or fields?

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

Re: Banner table

Anonymous — Thu, 28 Nov 2013 20:12:25 GMT

Sorry fields

Re: Banner table

Clever_Anjos — Thu, 28 Nov 2013 20:17:48 GMT

Maybe I´m missing something.

Is this what you want?

Re: Re: Banner table

Anonymous — Thu, 28 Nov 2013 20:32:06 GMT

Exactly.

Could you do it in my file?

Please see the attached file.

Thanks,

Re: Banner table

Clever_Anjos — Thu, 28 Nov 2013 20:35:38 GMT

Use

COUNT(1)/COUNT(TOTAL <MYear, [qID_5523_Monster visit freq]> [qID_5523_Monster visit freq])

as expression