topic Re: Multiple Expressions on a Chart in QlikView

Multiple Expressions on a Chart

Thu, 27 Mar 2014 18:18:54 GMT

Hello,

I have a requirement. Can we have multiple expression on a chart. I know we can create a line table and use conditional show/hide in expressions, but my requirement is user wants to select more than one expressions.

for e.g: I have a line chart. my Dimension is Month and i have these expressions

1) Cost

2) Revenue

3) Volume

4) Sales.

Now, the user wants to select any one expression at a time or all expressions at a time from a single list box.

Can we achieve this?

Thanks for you help

Vani

Re: Multiple Expressions on a Chart

its_anandrjs — Thu, 27 Mar 2014 18:26:13 GMT

Yes you can do this by creating a Inline table like

Dimension

LOAD * Inline

[

DimensionName

Cost

Revenue

Volume

Sales

];

and in your straight table chart or any chart in chart properties -> Expresions -> select conditional by tick mark and paste condition like

For

Cost-> if(DimensionName='Cost',1,0)

Revenue-> if(DimensionName='Revenue',1,0)

Volume-> if(DimensionName='Volume',1,0)

Sales-> if(DimensionName='Sales',1,0)

Hope this helps

Thanks & Regards

Re: Multiple Expressions on a Chart

its_anandrjs — Thu, 27 Mar 2014 18:28:50 GMT

Check attached snap shot for this

Hope this helps

Thanks & Regards

Re: Multiple Expressions on a Chart

Thu, 27 Mar 2014 18:32:50 GMT

Thanks Anand. But with this I can only select one value from the DimensionName at any time. My user would like to have the ability to select multiple DimensionNames at a time.

Thanks,

Vani

Re: Multiple Expressions on a Chart

Thu, 27 Mar 2014 18:34:01 GMT

A few things to keep in mind.

The solution provided by Anand is available in QV11.

If you are using QV10 you have to use Properties > Presentation > Conditional option.

This is not ideal though because this doesn't remove the expression, just simply hides it but in the background its still in the table just not visible to the user.

Else you have to overlay multiple charts over each other and use conditional show. This is a night mare.

Re: Multiple Expressions on a Chart

Anonymous — Thu, 27 Mar 2014 18:48:12 GMT

modify the conditions to something like

DimensionName like '*Cost*'

this will return true for multiple selections. you do not need the if(expression,1,0) as the expression in a conditional input field will return boolean anyway.

Re: Multiple Expressions on a Chart

jerem1234 — Thu, 27 Mar 2014 18:58:31 GMT

If you want to be able to select multiple you may also try in the conditional:

substringCount(concat(distinct Dimension), 'Cost')

match('Cost', $(=concat(distinct chr(39) & Dimension & chr(39), ',')))

You may replace concat() with GetfieldSelections() if you wish.

Hope this helps!

Re: Multiple Expressions on a Chart

Thu, 27 Mar 2014 19:04:12 GMT

Here is the chart that I have. Here I have Revenue and Volume which are always static. Above this chart is a list box which has multiple values (I used line table to create these). From this list box I can select only one value at a time and the chart will add one more line. But i would like to have the ability to select two or more values at a time. then there will be multiple lines in chart depending on the how many selections I did.

Thanks

Re: Multiple Expressions on a Chart

Anonymous — Thu, 27 Mar 2014 19:06:46 GMT

jerem, i always wondered if your method is better than the simple "like" comparison that i have been using now? i would like to use the method you suggested if it is better than the one i use performance wise.

Re: Multiple Expressions on a Chart

MK_QSL — Thu, 27 Mar 2014 19:11:48 GMT

Like this?

Re: Multiple Expressions on a Chart

jerem1234 — Thu, 27 Mar 2014 19:16:36 GMT

I've never have done a performance test on them with large data, so I am not sure as well. They are doing similar things, so I wouldn't expect a huge difference, but I could be wrong.

Re: Multiple Expressions on a Chart

Anonymous — Thu, 27 Mar 2014 19:21:29 GMT

ok thanks

Re: Multiple Expressions on a Chart

Thu, 27 Mar 2014 19:28:04 GMT

this might help u ..

Adhoc reporting in Qlikview

Re: Multiple Expressions on a Chart

Thu, 27 Mar 2014 19:49:22 GMT

Thanks. This is what I was looking.