topic Re: Crosstable problem in QlikView

Crosstable problem

michael_maeuser — Thu, 07 Jun 2012 11:25:44 GMT

Hi, I have a calculation with the dimension Product. Then I have a calculation scheme with about 10 steps. Per step I calculate an acutal and a budget value. I want it to look like the attached table. On the left side of the table i see the expression names. e.g. unit price. so if i add now an budget unit price, i will have another line. but i want it in the same line. just in another column. does anyone know how to do that?

Thanks in advance!

Michael

Crosstable problem

Thu, 07 Jun 2012 11:54:23 GMT

can you provide sample application with dummy data.

Crosstable problem

lironbaram — Thu, 07 Jun 2012 11:58:36 GMT

you can create a filed with the vlaues : Actual and budget

then use it as a dimension and in the expressions use an if statement

Re: Crosstable problem

michael_maeuser — Thu, 07 Jun 2012 12:10:20 GMT

attached is sample date. there are now 2 lines in the tabe with raw mat act. und raw mat budget. i would like to have one line Raw Material and then two columns (actual and budget). Thanks for helping!

@liron: I also thought of an field but this is not working very well

Re: Crosstable problem

lironbaram — Thu, 07 Jun 2012 12:57:10 GMT

check this one

Re: Crosstable problem

michael_maeuser — Thu, 07 Jun 2012 13:00:37 GMT

Yeah, but i have maybe like 10 steps in the calculation.

so next one is packaging material. and if now add the expression these costs it will be in a third column. but it´s supposed to be in the line below. do you know what i mean?

Crosstable problem

Thu, 07 Jun 2012 13:09:28 GMT

Hi Michael,

you can use ValueList('Name Of expression1','Name Of expression2','Name Of expression3') in Dimension (as calculated Dimension) and in Expression u need to write

If( ValueList('Name Of expression1','Name Of expression2','Name Of expression3')='Name Of expression1', Epression1,Expression2) .

I hope this will solve ur purpose..

Re: Crosstable problem

lironbaram — Thu, 07 Jun 2012 13:10:13 GMT

check this one

Crosstable problem

Thu, 07 Jun 2012 13:15:31 GMT

Hi Michael,

you can use ValueList('Name Of expression1','Name Of expression2','Name Of expression3') in Dimension (as calculated Dimension) and in Expression u need to write

If( ValueList('Name Of expression1','Name Of expression2','Name Of expression3')='Name Of expression1', Epression1,Expression2) .

I hope this will solve ur purpose..

Re: Crosstable problem

michael_maeuser — Thu, 07 Jun 2012 13:21:51 GMT

perfect thank you!!!