Discussion Board for collaboration related to QlikView App Development.
I have a Dimenson State
expression as Sales
I want to build chart like below showing states along with there sum(sales) and also saying status as per last weel (example higher than last week or better or lower)
I don't want to use Pie chart and do trellies.
I cannot do that because sometime states can be four or more as per the sales data.
If no sales then that state will not come.
And also what will be chart option for this rectangular box with a line and message(doing comparison with last week)
You don't want to do trellis and set analysis isn't possible. I guess you need some kind of magic . I am sorry, I am not aware of getting this done, but may be someone else do. In case someone do, I would be keen to know a solution as well.
There is no out the box solution in qlikview. As Sunny suggested you have to use "Trellis" or "separate charts".
Even if they are seperate charts you can control how many are visible based on your selection. Example create lets say 10 charts with set analysis where you capture your states in variables and use them set analysis. so based on selection/data lets say u have 4 states, then using layout condition of charts you will display first 4 charts and hide rest.
If above doesn't work, you have to build an extension. Look at samples here "branch.qlik.com".
It may be possible to get close to what you are asking for. Try the following
If you don't want to create so many objects, then you will either have to do without this visualisation, or you will have to create an extension.
(change the dimension, field names and expression as needed to fit your model)
I am going to go with threllies or set analysis but was swonderering do w ehave rectangular charts with a scale down in qlikview.
how can I get that layout