topic Sum only the selected dimension in QlikView

Sum only the selected dimension

Wed, 23 Jan 2013 13:20:14 GMT

Hello everybody,

first of all I want to explain the Situation.

I have a table with a few facts.

Facts are for example:

Incoming, Closed and Entry

And I create a new Dimension:

LOAD * INLINE [

Facts

Incoming

Closed

Entry

];

I want to display the facts in a chart.

Yes I dont need this dimension, but I want to use two Charts.

One Chart with all of these Facts and one Chart where I can see more details.

The Dimension will help me to choose the facts I want (i ve got more then 3... about 10)

So it would be nice to make a descission which fact i want to watch in detail.

Can you help me?

I startet du make a chart with the dimension facts.

Now I dont know how to write the expression to solve my problem...

Hope you can help me... may be I am on the wrong way

Re: Sum only the selected dimension

Gysbert_Wassenaar — Wed, 23 Jan 2013 13:29:29 GMT

If you're using QV11 you can use conditional display expressions for your chart dimensions and expressions. See attached file. Under Build Report you can select fields to show in the chart. If you look at the properties of that chart you can find the expressions to show/hide the dimensions and expressions in the Enable Conditional (for dimensions) and Conditional (for expressions) input fields.

Re: Sum only the selected dimension

Wed, 23 Jan 2013 13:51:31 GMT

Can you give me a Screenshot of this conditional display expression?

I cant open this File atm.

Re: Sum only the selected dimension

jagan — Wed, 23 Jan 2013 14:01:36 GMT

Hi,

PFA file, hope it helps you.

Regards,

Jagan.

Re: Sum only the selected dimension

Wed, 23 Jan 2013 14:08:06 GMT

I found a website to this topic (http://livingqlikview.blogspot.de/2012/01/conditional-dimensions-and-expressions.html)

I hope this can help me acutally. I will report

Re: Sum only the selected dimension

Gysbert_Wassenaar — Wed, 23 Jan 2013 14:10:12 GMT

Fields is the dimension with the names of the dimensions and expressions to show in the chart. The conditional expression for the expression Costs checks if the value 'Costs' is among the selected values in the Fields dimension.

Re: Sum only the selected dimension

Wed, 23 Jan 2013 14:13:12 GMT

Thanks this is the right way!

Actually thats not the way how I thougt to do this, but Its a soultion where I can live with.

Re: Sum only the selected dimension

Anonymous — Sat, 02 Feb 2013 19:44:24 GMT

Wassenaar,

I am not able to understand how this is working as i am a designer not a developer. Can you pls explain me to understand this. I got same kind of requirement from my client i want to deliver this by Monday. Can you pls help me here. Also i have posted a query in my page on this.

Rgds,

Nandha

Re: Sum only the selected dimension

Anonymous — Tue, 08 Jul 2014 14:15:39 GMT

http://livingqlikview.com/conditional-dimensions-and-expressions-tips-and-tricks/

This page moved. Living QlikView is now located here.