topic Separate chart for each Dimenson value in QlikView

Separate chart for each Dimenson value

New-Qlik — Wed, 25 Nov 2020 16:16:04 GMT

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.

Kindly guide

Thanks

Re: Sperate chart for each dimention value

sunny_talwar — Fri, 29 Jul 2016 05:22:55 GMT

I guess the only option left is to create three charts with set analysis in them to specify which Dimension State they need to show

Re: Sperate chart for each dimention value

New-Qlik — Fri, 29 Jul 2016 05:39:20 GMT

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)

Re: Sperate chart for each dimention value

sunny_talwar — Fri, 29 Jul 2016 05:42:34 GMT

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.

Best,

Sunny

Re: Separate chart for each Dimenson value

phaneendra_kunc — Fri, 29 Jul 2016 06:05:19 GMT

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".

Re: Separate chart for each Dimenson value

jonathandienst — Fri, 29 Jul 2016 06:39:26 GMT

It may be possible to get close to what you are asking for. Try the following

Create sufficient instances of the chart and lay them out in a way that makes sense
Add a conditional display as follows:
- If(FieldValueCount(myDimension) >= 1, 1, 0) (for box 1)
- If(FieldValueCount(myDimension) >= 2, 1, 0) (for box 2)
- ...
- If(FieldValueCount(myDimension) >= n, 1, 0) (for box n)
Use the following set analysis in the chart expressions
- Sum({<myDimension = {"$(=FieldValue(myDimension, 1)"}>} myValue) (for box 1)
- Sum({<myDimension = {"$(=FieldValue(myDimension, 2)"}>} myValue) (for box 2)
- ...
- Sum({<myDimension = {"$(=FieldValue(myDimension, n)"}>} myValue) (for box n)

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)

Re: Separate chart for each Dimenson value

New-Qlik — Fri, 29 Jul 2016 12:08:06 GMT

Thanks I will go with either of these but want to check do we have any charts like about rectangular box type

Re: Separate chart for each Dimenson value

New-Qlik — Fri, 29 Jul 2016 12:09:19 GMT

Thanks

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

Re: Separate chart for each Dimenson value

vinieme12 — Fri, 29 Jul 2016 14:49:14 GMT

Tried to match as much as possible , if it helps

Straight table on top with trellis bar chart overlay

second a pivot table with a linear gauge expression

Re: Separate chart for each Dimenson value

New-Qlik — Fri, 29 Jul 2016 17:28:05 GMT

This is perfect. Can you share your sample application where you have created this.

Thanks In Advance

Re: Separate chart for each Dimenson value

vinieme12 — Fri, 29 Jul 2016 17:45:23 GMT

it's attached on my post, on the second tab

Re: Separate chart for each Dimenson value

New-Qlik — Fri, 29 Jul 2016 19:10:02 GMT

How did you filled dimension name n sum(value) expression as blank

Re: Separate chart for each Dimenson value

New-Qlik — Fri, 29 Jul 2016 19:29:35 GMT

How to make dimension as blank (dim name)

Re: Separate chart for each Dimenson value

vinieme12 — Fri, 29 Jul 2016 20:55:28 GMT

just put space or =' '

Re: Separate chart for each Dimenson value

New-Qlik — Sat, 30 Jul 2016 08:39:54 GMT

yes I did same for expressions.

but not getting for dimension. Aplogies if its a silly question.

Re: Separate chart for each Dimenson value

vinieme12 — Sat, 30 Jul 2016 08:59:40 GMT

For the Label just press the spacebar

for the expression =' ' (= '<space>' )....

OR just copy my expression to your table.

post a screenshot so i know what you are looking at.

Re: Separate chart for each Dimenson value

New-Qlik — Sat, 30 Jul 2016 10:08:13 GMT