Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

laxmanqlik
Contributor

Combo chart in qlik sense

how to use combo chart in Qlik sense,

i am able to add the measures but it is not reflecting the chart and getting only bar chart.

can any one explain the complete process or share me the video link.

thank you

1 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: Combo chart in qlik sense

may be this will help

ColorMix1( rank(total column(1))/noofrows(TOTAL) , rgb(15,97,119), rgb(36,242,197))

change rgb value according to your color.

12 Replies
arulsettu
Honored Contributor III

Re: Combo chart in qlik sense

in second expression change like this

Untitled.png

Not applicable

Re: Combo chart in qlik sense

Hi Laxman,

Try changing you second Measure to Secondary axis. There may be a vast difference between the values of both the measures which must have caused this problem.

Regards,

Rohan

laxmanqlik
Contributor

Re: Combo chart in qlik sense

Thank you Rohan,

can you help me with the following issue,

@

i have a straight table with customer and sales

i need to sort the table with descending order of Sales

and i need sales values should be in sequential gradient

can any one help me to resolve it.

Not applicable

Re: Combo chart in qlik sense

Hi Laxman,

Add the dimension and measure in your straight table.

Go in the Sorting tab and make sure that Sales is your first preference for sorting. If not, drag it at the top.

Select Custom and then Descending.

Like the screen shot given below.

screen.PNG

Regards,

Rohan

laxmanqlik
Contributor

Re: Combo chart in qlik sense

Got it ,

but how to change the colour of text  or  field values dynamically

Not applicable

Re: Combo chart in qlik sense

In Data tab, under the Sales tab, you will find those properties.

screen 2.PNG

You can define your conditions here which will help in dynamically changing the background and text colour.

Regards,

Rohan

gompa786
Contributor III

Re: Combo chart in qlik sense

Hi Laxman do you mean like this :

Thanks

laxmanqlik
Contributor

Re: Combo chart in qlik sense

Thanks Chandra,

but it not matching to my exact requirement

The colour of the highest value should dark and the lower values are little bit light in the same colour.

please have a look at the highlighted ones .

i want my data in a table to be in this kind of colour pattern.

Screenshot (4).png

gompa786
Contributor III

Re: Combo chart in qlik sense

Looking for this:

for the measure in the background colour expression I have use the below expression

if(rowNo()/2=floor(rowNo()/2),RGB(255,128,0),RGB(255,153,51))

you can get the colour coding for RGB from the internet link below:

http://www.rapidtables.com/web/color/RGB_Color.htm