topic Re: Max from possible values (even not selected) - bar chart in QlikView

Max from possible values (even not selected) - bar chart

Anonymous — Tue, 09 Feb 2016 14:00:12 GMT

Hi Guys,

I'm trying to do bar chart which should be no sensible for any selections in listbox Month (January - December , 12 values).

At the beginning this bar chart was working like that:

when you clicked on Month list box for example for June, on chart you saw all months cummulative sums from January to June

I did this among other with expression: Month={"<=$(=Max(Month))"}

Now i would like to have always all months from January to December (all months from Month listobox) on this bar chart which should be not sensible for any selections in Month listbox.

So when you will click on June, on Bar Chart You will see amounts from January to December.

Could you please help me with acheving that?

Thank you in advance for your help,

Jacek Antek

Re: Max from possible values (even not selected) - bar chart

swuehl — Tue, 09 Feb 2016 14:40:56 GMT

Maybe just clear the month field selection?

Sum( {< Month= >} Value)

edit:

Sum( {< Month= {"<=$(=Max({1} Month))"}>} Value)

Re: Max from possible values (even not selected) - bar chart

hic — Tue, 09 Feb 2016 14:43:01 GMT

A Set Analysis expression selecting all months should do the trick:

Sum( Month={"*"} Amount )

HIC

Re: Max from possible values (even not selected) - bar chart

Anonymous — Wed, 10 Feb 2016 07:59:06 GMT

Thank You for your swift answer,

This expression:

Sum( {< Month= {"<=$(=Max({1} Month))"}>} Value)

did the good work

Best Regards,

Jacek Antek