Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bijoylalu
Contributor

Visualization similar to this

Visualization similar to below graph/bar.

Capture.JPG

Here actually two dimensions and one measure is there. Dimension1 is year and Dimension2 represents two entities(one represented by blue bar and another by Yellow line). Is any visualization available in branch.qlik.com to acheive the same ??

1 Solution

Accepted Solutions
bijoylalu
Contributor

Re: Visualization similar to this

I got the answer for this.

    I created a combi chart, with two measures.

    Each with Measure 1 expression: avg({<[BANK]={'Bank1','Bank2','Bank3','Bank4'}>}Amount)

                    Measure 2 expression sum({<[BANK]={'Bank5'}>}Amount)

                   More over, made view of Measure1 to Bar in properties and Measure2 to line.

                   Its working perfect for me

5 Replies

Re: Visualization similar to this

No. You'll have to use a combi chart with two expressions; one for the bars and one for the line.

line: sum({<Dim2={'Foo'}>} Amount)

bars: sum({<Dim2={'Bar'}>} Amount)


talk is cheap, supply exceeds demand
bijoylalu
Contributor

Re: Visualization similar to this

It is not working. Attaching how i tried with the same.

Capture.JPG

Re: Visualization similar to this

I think you should google for the origin of Foo and Bar.


talk is cheap, supply exceeds demand
bijoylalu
Contributor

Re: Visualization similar to this

I got the answer for this.

    I created a combi chart, with two measures.

    Each with Measure 1 expression: avg({<[BANK]={'Bank1','Bank2','Bank3','Bank4'}>}Amount)

                    Measure 2 expression sum({<[BANK]={'Bank5'}>}Amount)

                   More over, made view of Measure1 to Bar in properties and Measure2 to line.

                   Its working perfect for me

Re: Visualization similar to this

Great. Well done. Can you mark this question as answered so other users with the same question can find it more easily?


talk is cheap, supply exceeds demand
Community Browser