topic Re: Wrong weeks in Last 12 weeks in Bar chart in QlikView

Wrong weeks in Last 12 weeks in Bar chart

rkpatelqlikview — Thu, 26 Apr 2018 13:34:28 GMT

Hi Qlik,

I have given expression for Week. I need to show last 12 weeks but after selection its showing like this.

I need to last 12 weeks even there is no data.

In bar chart unchecked these options -> Suppress null values, Show all values and suppress zero values.

and its showing only odd numbers.

=Round((sum({< Datums=,WEEK1= {">=$(=MAX(WEEK1)-11)"}>} $(sumkm) )/sum({<Datums=,WEEK1= {">=$(=MAX(WEEK1)-11)"}>} [Kms Travelled])*1000))

after click on the Clear its showing last 12 weeks

Thanks for your support.

Re: Wrong weeks in Last 12 weeks in Bar chart

bc-thebruuu — Thu, 26 Apr 2018 13:35:53 GMT

Can you post your application?

Can you show us the selected fields?

Re: Wrong weeks in Last 12 weeks in Bar chart

rkpatelqlikview — Thu, 26 Apr 2018 13:58:52 GMT

Thanks for your response Bruno,

Please find the attached.

Re: Wrong weeks in Last 12 weeks in Bar chart

bc-thebruuu — Thu, 26 Apr 2018 14:01:21 GMT

Take a look @ my solution.

Show all values + one expression (hidden) =1

You just need to modify it in order to get 1 for last 12 months

Re: Wrong weeks in Last 12 weeks in Bar chart

rkpatelqlikview — Thu, 26 Apr 2018 15:02:15 GMT

Thanks Bruno, But here its showing all the weeks. It should show only 12 weeks. Just entered the vehiclenumber "MH46F4529". It should show only last 12 weeks. If there is no data then with empty space.

Re: Wrong weeks in Last 12 weeks in Bar chart

bc-thebruuu — Thu, 26 Apr 2018 15:03:51 GMT

As I told ...the expression =1

should be if date in the last 12 month then 1

Re: Wrong weeks in Last 12 weeks in Bar chart

rkpatelqlikview — Thu, 26 Apr 2018 15:25:10 GMT

Agreed Bruno, Many thanks for your help.

Just i asked can we hide the remaining weeks also.

Re: Wrong weeks in Last 12 weeks in Bar chart

bc-thebruuu — Thu, 26 Apr 2018 15:32:20 GMT

I'll send you the qvw

Last thing to do was to add alternate state ...

in this way the dimension line (independent from selection remains the same wahtever the selection you do on the alternate state)

BUT formulas are dependent on alternate state

Re: Wrong weeks in Last 12 weeks in Bar chart

rkpatelqlikview — Thu, 26 Apr 2018 15:40:25 GMT

Thanks Bruno.

Re: Wrong weeks in Last 12 weeks in Bar chart

rkpatelqlikview — Fri, 27 Apr 2018 05:13:53 GMT

Excellent Bruno, Its working now. Many thanks for your great support