topic Re: Show values from excel in QlikView

Show values from excel

Tue, 18 Feb 2014 09:55:32 GMT

Hi all.

This is probably a very simple question but I have come to a stop...

I have a excel where I have collect some goal values and would like do use them in combo charts.

Have tried with example only({$<GoalStation={"CoachDialog"}>} Value) but don't get the value 90%.

Atteched the excel.

Thanks!

Re: Show values from excel

datanibbler — Tue, 18 Feb 2014 10:02:44 GMT

Hi Björn,

looking at the Excel, "GoalStation" should naturally be your dimension, yes?

Why do you want to display the value for only one of those?

If you want to use the above as an expression to display, try with an IF_construct instead.

Your set_expression actually looks correct to me, but sometimes you just have to try out different aggregation_functions - or try single_upper_quotes instead of the double quotes.

HTH

Best regards,

DataNibbler

Re: Show values from excel

Tue, 18 Feb 2014 10:04:10 GMT

Hi Björn Larsson,

I tried the same example and able to get the 90%. May be you might having selections made in the QVW, so that the value is not displaying because of $ in the expression. If you want to show the value irrespective of selection, use 1 instead of $. The below is the qvw i created for ref.

Re: Show values from excel

hic — Tue, 18 Feb 2014 10:07:41 GMT

This should work. What do you get if you skip the Set analysis and just make a simple pivot table with GoalStation and Year as dimensions and Avg(Value) as Expression?

HIC

Re: Show values from excel

nizamsha — Tue, 18 Feb 2014 10:10:12 GMT

PFA