topic Making a Chart or TableBox filter for a specific value in QlikView

Making a Chart or TableBox filter for a specific value

Tue, 01 Mar 2011 12:39:25 GMT

Hi,

I'm trying to make a chart or tablebox display only specific values as in the sql 'where' statement e.g. I want to show all the values for a specific year / month in on box e.g. Jan 2010 in one and then Feb 2010 in the next (In reality the year will be picked elsewhere)

or. Can I do the same for columns, like Sales / Quanity for Jan, Sales / Quantity for Feb ansd so on.

Thanks

John

AW:Making a Chart or TableBox filter for a specific value

brenner_martina — Tue, 01 Mar 2011 12:43:33 GMT

Hi,

you can enter a dynamic dimension like: If(year=2011,year)

and in the expression enter:

Sum(If(year=2011 And Month=1, Sales)

Making a Chart or TableBox filter for a specific value

Tue, 01 Mar 2011 12:50:40 GMT

Hello Jhon,

Please take Month_Year as dimension and Sales , Quantity etc in Expression .

It will show all the sales , Quantity for the Month_ Year Wise as in your calender.

Making a Chart or TableBox filter for a specific value

Tue, 01 Mar 2011 13:12:16 GMT

Works in part, but not as hoped.

Maybe looking at it as showing summary values by month by customer may help

Thanks

John

Making a Chart or TableBox filter for a specific value

suniljain — Tue, 01 Mar 2011 13:13:34 GMT

you can also write expression in dimention .

so that your dimention value dispalyed for selected parameter.

Making a Chart or TableBox filter for a specific value

suniljain — Tue, 01 Mar 2011 13:15:35 GMT

Dear John,

you can also group by sales on Year,Month basis . it will solve your problem

Making a Chart or TableBox filter for a specific value

marcohadiyanto — Tue, 01 Mar 2011 13:16:36 GMT

hi,

you can create bar chart and make "YearMonth" as dimension and Sales/Quantity as Expression.

then it will give you chart for comparison between year and month and will given value from sales/quantity.

regards

Making a Chart or TableBox filter for a specific value

Wed, 02 Mar 2011 16:44:42 GMT

This is what I've done. Its not ideal but the user is totally happy now (users are strange)

Thanks all for your help