topic Re: How I get the Numbers with x ? in QlikView

How I get the Numbers with x ?

Thu, 03 Jan 2013 15:49:24 GMT

Hello,

my next problem, I have two columns external and amount days. I need only the days with x in the same row.

After that I need to calculate the Average days of the external.

Could you help me, to give me the spirit to the solution.

Thanks.

adamwilson — Thu, 03 Jan 2013 16:27:34 GMT

Hi,

To calculate the average days of External, create a chart, use External as your dimensions and Avg([Amount of days]) as you expresion.

This will result in one row for each distinct value in External with the average of Amount of days.

Adam

Gysbert_Wassenaar — Thu, 03 Jan 2013 20:34:19 GMT

If you need the average of the days where External has the value 'x' try this expression in a text box:

=avg({<External={'x'}>} [Amount of Days])

Fri, 04 Jan 2013 09:10:22 GMT

Thank you it works.

But can you me explain, why do you need the {<{}>} formulas?

khadeer — Fri, 04 Jan 2013 09:18:25 GMT

That function is written in set analysis, that is necessary for set analysis.

Fri, 04 Jan 2013 12:23:57 GMT

How can I get the formular in a YTD Formular:

This here is my try, but it doesn't work:

Could you help me.

Thanks.

Gysbert_Wassenaar — Fri, 04 Jan 2013 17:16:06 GMT

Try: avg({<Year={$(vMaxYear)},Date={'<=$(vMaxDate)'},Month=,[FAK Kennzeichen]={'X'}>} [Anz Tage])

This all assumes you have fields called Year, Month and Date and a variable called vMaxDate that contains a valid date value.

Mon, 07 Jan 2013 09:37:30 GMT

Thank you, it is the right answer.