Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
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.