Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can people please clarify and confirm that you can't replicate charts in Qlikview.
So here is standard setup of data in excel to create a line/bar chart:
The chart I'm looking for is:
However, this same format in Qlikview doesn't work and so the chart above can't be replicated. I have to transpose the data like so then it works...can people please confirm is this normal?:
Chris
Hi,
Just create copy of the charts and add following expression in chat.
Sum({<Indicator = {"Ref 1"}>}Value)
Sum({<Indicator = {"Ref 2"}>}Value)......
Regards,
Kaushik Solanki
Hi
Try like this
Properties -> Presentation -> Check "Horizontal" checkbox.
Hi
Hope you are asking in Straight table and with 5 expression..
Hi,
This is normal. You don't need to worry about changing the excel and transpose the data. QlikView has functions which will help you to do that automatically.
Regards,
Kaushik Solanki
See Crosstable in help in order to import data easily into QlikView from your format.
The resulted table in QlikView should look like:
RefName | Month | Value |
---|---|---|
Ref1 | Ian | 1 |
Ref2 | Ian | 2 |
Ref1 | Feb | 3 |
Ref2 | Feb | 4 |
Hi Chris,
1. Which chart are you struggling with?
2. What format is you load data in?
Andy
See attached app. I have put data into a straight table and added each month as an expression - is this correct?
However, its the chart I want to work. I want a line chart fr each Indicator: Ref 1, Ref 2 etc.
Hi Chris,
I have manipulated the data and done the chart which you are looking for.
Have a look at the attached example.
Regards,
Kaushik Solanki
HI
PFA
Hi,
Great, but I need to split the charts up - chart for ref 1, one for ref 2 etc.
This app will be used as a dashboard.