topic Adding Custom Dimension in QlikView

Adding Custom Dimension

Anonymous — Fri, 27 Mar 2015 16:57:51 GMT

Hi All

In attached QV how do I add custom Variance (Q1-14 - Q2-14) column. Here Q1-14, Q2-14 are dimensions

Thanks

buzzy996 — Fri, 27 Mar 2015 17:57:42 GMT

on expression tab u can create "Q1-14 ,Q2-14 ..etc"and play with rows & columns to move

Anonymous — Fri, 27 Mar 2015 18:39:04 GMT

Hi Shiva

I appreciate your reply.

In this case dimensions are not static

pokassov — Fri, 27 Mar 2015 19:12:51 GMT

Hi Satish!

If I understood you correctly, you can:

1. change your expression

if(SecondaryDimensionality()=2,Sum(Amt), Sum({$<QtrHead={'$(=MinString(QtrHead))'}>} Amt)-Sum({$<QtrHead={'$(=MaxString(QtrHead))'}>} Amt))

2. set on the Presentation tab "Show Partial Sums"

And then you will be able to see your chart in the following way:

Anonymous — Fri, 27 Mar 2015 19:59:14 GMT

Dear friend

I appreciate your answer, it's really helpful

Thanks