Qlikview charts

[neha_sri]

hi,

I have a scenerio where I have a loading month which contains values of a particular good for 12 months i.e Jan-Dec in a bar chart.Now I want that when I select loading month Jun,I should be able to see Month from Jan to jun in green colour and rest months in red colour, again If I select loading month Mar, I should be able to see in bar chart month jan to mar in green colour and rest months in red colour..

How can I do this in front end

Thanks in anticipation

[Anonymous]

look at this

[neha_sri]

I didnt find any attachment.pls reply soon..

Thanks

[Anonymous]

should be attached, please check

[veidlburkhard]

Hi Neha,

this is a solution without makro. Please see the picture:

The expression for the color of the bars is:

If(MonthNum <= Match(Month, 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'), RGB(0, 255,0), RGB(255, 0, 0))

Hope this helps

Burkhard

[veidlburkhard]

Hi Neha,

last night I had the idea of a much more elegant solution to your problem.

Please, follow these 3 steps:

i) this is your script to use

ii) Add an alternate state to your app, e. g. 'A' and chose this state for  the month listbox where your user will do the selections on the month

iii) Create a variable and assign this value to it: =Only({A}MonthNum), don't forget the equal sign.

Use this variable in the expression for the color of the bars in your chart.

That's it.

Happy qliking

Burkhard