topic Re: Linechart Display by Qtr Only in QlikView

Linechart Display by Qtr Only

gerrycastellino — Mon, 05 Jun 2017 19:46:54 GMT

I need to get this line chart to display the beginning quarter dates only, and ignoring any selection on the

date in the list box.

see attached qvw file.

I would want to see the following %'s:

9.09%

50%

95.89%

3.85%

THankx !

Gerry.

Re: Linechart Display by Qtr Only

sunny_talwar — Mon, 05 Jun 2017 19:54:15 GMT

May be this

If(Category = 'Green' and Mod(Month(SaleDate), 3) = 1, Aggr(Sum(Sales), SaleDate, Category)/Sum(TOTAL <SaleDate> Sales), Null())

Re: Linechart Display by Qtr Only

gerrycastellino — Mon, 05 Jun 2017 20:03:56 GMT

Sunny:

Thankx, I also need it to ignore the date selection.

Re: Linechart Display by Qtr Only

sunny_talwar — Mon, 05 Jun 2017 21:05:02 GMT

Try this

If(Only({<SaleDate>}Category) = 'Green' and Mod(Month(Only({<SaleDate>}SaleDate)), 3) = 1, Only({<SaleDate>} Aggr(Sum({<SaleDate>}Sales), SaleDate, Category))/Sum({<SaleDate>} TOTAL <SaleDate> Sales), Null())