replicate sight

[pgalvezt]

Hello,

I have a complete model created with the goal to show sales by month.

Now I have to add a new sight. I could show 2014 and 2015 sales as rows. But I have problem with the budget, because I need to add that row... the same view such as an excel view and formulas and colours.

The Sheet is called "Reporte de Ventas". There is where I working out right now.

The weight model was 56 MB. The model now weight 1 MB with reduction data (so I just showing January).

I don´t know if its possible to add the different rows.

Thanks!

[settu_periasamy]

Hi,

If you are using straight table, May be you can try with ValueList() function in Add Calculated Dimension..

[pgalvezt]

Hi settu,

Thank you for your reply,

I use a pivot table because If I use a straight table, qlikview show values vertically.

If you see the excel test you could see that the values are horizontally defined.

[settu_periasamy]

Hi,

Do you want like the below screen shot?

If yes, you can try with valuelist in a calculated dimension. And, Pick..Match in the expression.

find attached for reference.

[pgalvezt]

Hi,

Yes, I put an Excel File, I have to replicate it.

[pgalvezt]

Ok,

I could show budget and actual year,

but when I select 2014 plus 2015... Budget dissapear.

Can you help me with that?

Thanks!

[settu_periasamy]

Hi,

If your dimension value is static, you can use the value list and Pick.. Match.

May you can try to add the Budget field in the Script level like 2014, 2015 and Budget..