Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Can you post your application?
Can you show us the selected fields?
Thanks for your response Bruno,
Please find the attached.
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
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.
As I told ...the expression =1
should be if date in the last 12 month then 1
Agreed Bruno, Many thanks for your help.
Just i asked can we hide the remaining weeks also.
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
Thanks Bruno.
Excellent Bruno, Its working now. Many thanks for your great support