Discussion Board for collaboration on QlikView Scripting.
I'm working on a requirement where i do not have a dimension, but only its values.
For eg: I have Zone1, Zone2, Zone3, and Zone4
I have only numbers in all the 4 fileds.
I did the sum() all the numbers in chart, without dimension, it looks like
Zone1 Zone2 Zone3 Zone4
But i wanna display it like
By adding some manual dimension in chart or in script.
Any help will be highly appreciated.
Please find the application attached.
Go to Solution.
This works -
Load * Inline [
Zone1, Zone2, Zone3, Zone4
Dimension - =ValueList('Zone1','Zone2','Zone3','Zone4')
Expression - pick(match(ValueList('Zone1','Zone2','Zone3','Zone4'),'Zone1','Zone2','Zone3','Zone4'),MaxString(Zone1),MaxString(Zone2),MaxString(Zone3),MaxString(Zone4))
Sum([Zone1 Units]) as Zone1Units,
Sum( [Zone 2 Units]) as Zone2Units,
Sum( [Zone 3 Units]) as Zone3Units,
Sum([Zone 4 Units]) as Zone4Units
(ooxml, embedded labels, table is Sheet1);
Just checked i req that expression needs sum,like that-
Set the "Total mode" under Expressions to No Total.
Under Presentation, check the "Horizontal" checkbox.
This works exactly Mr. Singh.
This is really genius thing and awesome.
Thanks a ton.
Sum() in the background helped me to get the chart in the right format.
Never knew that we can sum() without any dimension and group by.
Learning lot of things as i'm beginner.
Hi Mr. Gulbrandesn,
Thank you for your help.
Learnt a new thing that we can use "Horizontal" in the table.
Thanks again sir.