topic Re: Suppress data in QlikView

Suppress data

Wed, 25 Nov 2020 16:16:04 GMT

I've created the following graph...

...and the user has the ability to select the year, i.e. 2014-2015, 2015-2016, 2016-2017 using a filters box. The screenshot above is for 2016-2017. How can I suppress the months July through to March as in reality, we don't know the figures for those yet? I believe the graph would look a lot tidier if only the current / past months were visible.

I'm using a dimension of 'Month' and the Void Loss expression is... num(rangesum(above(sum([Void Loss Amount]), 0, rowno())))

Many thanks.

Mel.

Re: Suppress data

Digvijay_Singh — Tue, 28 Jun 2016 11:24:52 GMT

Instead of 'Month' use the dimension something like if(Month<=Month(today()) and Year<=Year(today()),Month)

Re: Suppress data

Tue, 28 Jun 2016 13:02:19 GMT

Thanks for that. I'm getting there but not quite. I haven't incorporated the year just yet...

...the months Apr through to Jun are exactly what I would expect but I don't want to see Jan through to March. Our year field is called 'Fiscal Year' which is a financial year and starts in April and ends in March. Any further advice would be much appreciated.

Many thanks,

Mel.

Re: Suppress data

Anonymous — Tue, 28 Jun 2016 13:08:00 GMT

does your customer have a diffferent fiscal year (apr-march)?

do you have a master calendar?

my customer has the same fiscal year. I provided additional fields for fiscal year

(as fiscal year, fiscal month, fiscal quarter) to master calender and use these fields

in charts

Re: Suppress data

Digvijay_Singh — Tue, 28 Jun 2016 13:14:48 GMT

I think yeartodate can help here, if(yeartodate(Your date field, 0,4,today()),Month)

Re: Suppress data

Anil_Babu_Samineni — Tue, 28 Jun 2016 13:47:56 GMT

super_salmon

Let me know if you want to click any month you want to show the data for previous of selection or forward of selection.

- Anil Chowdary

Re: Suppress data

Tue, 28 Jun 2016 13:54:24 GMT

Thanks Anil... still need to tackle the year to date bit first

Re: Suppress data

sunny_talwar — Tue, 28 Jun 2016 14:12:30 GMT

This might not work if you have other months where Sum([Void Loss Amount]) is equal to 0, but give this a shot:

If(Sum([[Void Loss Amount]) > 0, RangeSum(Above(Sum([Void Loss Amount]), 0, RowNo())))

RangeSum(Above(Sum([Void Loss Amount]), 0, RowNo())) * Sum([[Void Loss Amount])

Have not tried this second expression, but worth testing it out as it avoids using the if statement

Re: Suppress data

Tue, 28 Jun 2016 14:19:49 GMT

Thanks Sunny... the 'IF' statement has given me exactly what I was after...

Star... as always