topic Re: Re: bar chart & button combination problem in QlikView

bar chart & button combination problem

Fri, 19 Sep 2014 00:36:13 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 once again click 12 months it display current selection-12 months data in bar chart.

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

Re: bar chart & button combination problem

phaneendra_kunc — Fri, 19 Sep 2014 00:42:55 GMT

Can you post a sample QVW?

i kind of got your intention of the button click. It will be easy for me to solve in your sample QVW rather than me creating a sample.

Re: bar chart & button combination problem

Fri, 19 Sep 2014 02:33:05 GMT

how to write the expression in bar chart plz tell me......don't have any sample dashboard

Re: Re: bar chart & button combination problem

JonnyPoole — Fri, 19 Sep 2014 03:16:37 GMT

Here is a sample with the button you descibe and a conditional expression that shows the regular current selections vs only last 12 months

There are 2 buttons. They both set the variable vToggle. They both have a layout show/hide condition. The button that sets to 'current selections' only shows when vToggle='Last 12 Months' and vice versa.

I use a data calendar that numbers the months sequentially from oldest monthyear (1) to latest monthyear (in this case 83)

here is the load script:

Data:

LOAD

[Transaction ID],

Sales,

[Gross Margin],

Date,

year(Date)*100 + month(Date) as YearMonth

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

MonthCalendar:

load Distinct

AutoNumber(YearMonth) as MonthSequenceNumber,

YearMonth

Resident Data

Order by YearMonth Asc;

I have a variable that stores the current month:

vCurrentMonth: =max(MonthSequenceNumber)

The expression for last 12 months in the chart is

if (vToggle='Current Selections',

sum(Sales),

if( vToggle='Last 12 Months',

sum( {$<Date=,YearMonth=,MonthSequenceNumber={'>=$(=vCurrentMonth-12)'}>} Sales)

)

here are the screenshots

Then press ' show last 12 months' and get this:

(button is toggled and the chart is filterd to last 12 months)