topic Re: replicate sight in QlikView

replicate sight

pgalvezt — Tue, 15 Sep 2015 12:56:12 GMT

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!

Re: replicate sight

settu_periasamy — Tue, 15 Sep 2015 16:04:29 GMT

Hi,

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

Re: replicate sight

pgalvezt — Tue, 15 Sep 2015 17:03:17 GMT

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.

Re: replicate sight

settu_periasamy — Tue, 15 Sep 2015 17:49:49 GMT

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.

Re: replicate sight

pgalvezt — Tue, 15 Sep 2015 18:27:20 GMT

Hi,

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

Re: replicate sight

pgalvezt — Tue, 15 Sep 2015 19:37:29 GMT

Ok,

I could show budget and actual year,

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

Can you help me with that?

Thanks!

Re: replicate sight

settu_periasamy — Wed, 16 Sep 2015 02:34:51 GMT

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..