topic Re: Need helpppppp in App Development

Need helpppppp

anjanak — Thu, 12 Aug 2021 16:16:11 GMT

I am a beginner in Qliksense I have data in this format

Value type Value Period

Actual 50.5 1/8/21

Target 80.10 1/8/21

Actual 70.5 1/7/21

Target 73.5 1/7/21

Now I need to plot a bar chat With Period as X-axis And

Actual Value as Y-axis And a trend line of the target value

Please help me with how to get this done

Re: Need helpppppp

stevejoyce — Thu, 12 Aug 2021 16:31:40 GMT

Use Combo chart.

Dimension = Period

Expression1 = Sum({<Value type={'Actual'}>} Value) , display as bar

Expression2 = Sum({<Value type={'Target'}>} Value), display as line

Re: Need helpppppp

anjanak — Thu, 12 Aug 2021 16:36:55 GMT

Hi Steve , thanks for the reply

But I want to display the exact values not the aggregates like sum / count

Every month has unique actual and target value

I have to display just actual value without any aggregation for that particular month ..and a trend line displaying the target value for that month

Like wise for all months ..

Re: Need helpppppp

stevejoyce — Thu, 12 Aug 2021 16:42:18 GMT

Did you use the calculations and see what happens? I don't understand your concern. You need some function around your field (max, sum, avg...). If you only have 1 value and that's what you want to display then really your function doesn't matter. If there is something else going on, please share details.

Re: Need helpppppp

anjanak — Thu, 12 Aug 2021 16:52:13 GMT

Jan to Dec I have two set of Values one Is actual and other is Target

I don't need any aggregate functions here

I just need to plot for every month how much is actual (achieved) vs how much target we set for that particular month

Like wise for every month data needs to be plotted

The one you said is throwing an expression error

Re: Need helpppppp

stevejoyce — Thu, 12 Aug 2021 17:23:55 GMT

Enclose your field names in [ ]. The set analysis is what limits to actual vs target. If that's unclear I recommend you do some research on expressions and set analysis. This is a straightforward calculation.

Sum({<[Value type]={'Actual'}>} [Value])

Sum({<[Value type]={'Target'}>} [Value])