No

[anjanak]

I am beginner in Qliksense 

I have a 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 target value .

Please help me with how to get this done

[kaushiknsolanki]

Hi,

Create a Line chart with dimension as Period and two expressions as below.

1. For Actual - Sum({<ValueType = {"Actual"}>}Value)

2. For Target - Sum({<ValueType = {"Target"}>}Value)

[anjanak]

The problem with the solution is ..

I will get the sum of all the data for that month ..

So I will give brief overview of data

 Agenda is to display 

Performance for Each Region monthly 

Time was yearly or monthly we need to filter that part as well ...

It's either monthly or yearly.

Each month either monthly or yearly performance tracker is there have to consider one .

And plot the chart 

[kaushiknsolanki]

In such case I will do below.

Create a bar chart 

Create a bar chart with dimension as Region and two expressions as below.

1. For Actual - Sum({<ValueType = {"Actual"},time = {"$(=Maxstring(time))"}>}Value)

2. For Target - Sum({<ValueType = {"Target"},time = {"$(=Maxstring(time))"}>}Value)

With this, you will get 2 Bars for each Region and when you don't select anything in "time" field, it will take the maximum value i.e. Yearly. When you select Monthly it will show Monthly data.