topic Re: Ideas for showing multiple expression in Graph/Chart? in QlikView

Ideas for showing multiple expression in Graph/Chart?

shyamcharan — Thu, 16 Jun 2016 05:43:28 GMT

Hi Experts,

I have around 20 expressions.

I am looking for ideas to show these expressions and the variance compared to last year in a graphical manner.

(like using Variance=sum(sales)-Above(sum(sales)))

Is there out a better way of showing these many expressions and their variances?

Apart from this, I am showing the data(expression and variance) in Tabular form using the Pivot table.

However, wondering if there is any bright idea that could use minimum space and show the required?

Thanks in advance.

Re: Ideas for showing multiple expression in Graph/Chart?

Anonymous — Thu, 16 Jun 2016 05:51:33 GMT

Not sure, but I think this is the only option like you have to write the variance expression for every expression.

I hope every expression like Sales, Cost, Profit etc...its not like conditional bases?

Re: Ideas for showing multiple expression in Graph/Chart?

shyamcharan — Thu, 16 Jun 2016 05:54:44 GMT

Hi Balraj,

Yes the expressions are time intervals for various activities. Not conditional.

They are all straight calculated fields from Database.

thanks for the quick response.

Re: Ideas for showing multiple expression in Graph/Chart?

Anonymous — Thu, 16 Jun 2016 05:54:55 GMT

For Multiple expressions you can try using Radar Chart . Bu the Dimension should be one for all expressions.

Re: Ideas for showing multiple expression in Graph/Chart?

vikasmahajan — Thu, 16 Jun 2016 06:04:32 GMT

From qlikview installed path C:\Program Files\QlikView\Examples\Documents\Data Visualization.qvw

Refer this , is a very good example for visualizations.

Hope this help you

Vikas

Re: Ideas for showing multiple expression in Graph/Chart?

avinashelite — Thu, 16 Jun 2016 06:08:22 GMT

The approach your following rite, that the better way to show that . In Straight and Pivot table you have the flexibility to adjust the cell width height etc .

Re: Ideas for showing multiple expression in Graph/Chart?

avinashelite — Thu, 16 Jun 2016 06:15:25 GMT

if you have got the answer please mark the correct and helpful answers