topic Re: button & bar chart problem in QlikView

button & bar chart problem

Thu, 18 Sep 2014 09:35:55 GMT

i have one bar chart and one button in that button two clicks are their one is current selection and another one is 12 months

if i click the current selection the bar chart it display the current seletion data . and click 12 months it display current selection-12 months data in bar chart. plz tell me urgent....

Re: button & bar chart problem

MK_QSL — Thu, 18 Sep 2014 09:36:41 GMT

Provide sample data please...

Re: button & bar chart problem

senpradip007 — Thu, 18 Sep 2014 09:40:43 GMT

Use two expression with conditional enable facility.

For 12 month data

Sum({<Date={'>=$(=AddMonths(Max(Date),-12)) <=$(=Max(Date))'} >} Value)

Re: button & bar chart problem

MayilVahanan — Thu, 18 Sep 2014 09:43:38 GMT

Try like this

Current selection

=Sum({<DateField = {">=$(=MonthStart(Max(DateField))) <= $(=Date(Max(DateField)))"}>}MeasurementField)

Current selection - 12 month

=Sum({<DateField = {">=$(=MonthStart(Max(DateField),-12)) <= $(=Date(Max(DateField)))"}>}MeasurementField)

You can replace 12 in variable and use it in the button also and optimize in one expression.

Re: button & bar chart problem

Thu, 18 Sep 2014 10:56:51 GMT

in the above statements in place of measurement field I use count( if(op_status='won',op_status))/count(op_status)

it work or not other wise plz give information about this... urgent

Re: button & bar chart problem

Thu, 18 Sep 2014 11:06:23 GMT

any one plz help me

Re: button & bar chart problem

MayilVahanan — Thu, 18 Sep 2014 11:31:27 GMT

Try something like this

count({<DateField = {">=$(=MonthStart(Max(DateField))) <= $(=Date(Max(DateField)))"}, op_status={'won'}>}op_status))/count({<DateField = {">=$(=MonthStart(Max(DateField))) <= $(=Date(Max(DateField)))"}>}op_status)

Re: button & bar chart problem

Thu, 18 Sep 2014 17:34:37 GMT

i am calculating the both current selection and 12 months in bar chart . in button object wrote this code like if(vtogle_something='last',12months,current selection)

i m using this code to write the expression in bar chart like (if vtogle_some='last',

i don't next and also using the condition(expression like rate%)

count( if(op_status='won',op_status))/count(op_status) to display the bar chart corresponding clicks in one button object plz tell me the working expression........plz........urgent