Combo chart in qlik sense

[laxmanqlik]

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

[arulsettu]

in second expression change like this

[#3]

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]

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.

[#5]

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.

Regards,

Rohan

[laxmanqlik]

Got it ,

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

[#7]

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

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

Regards,

Rohan

[Anonymous]

Hi Laxman do you mean like this :

Thanks

[laxmanqlik]

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.

[Anonymous]

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