Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
gerrycastellino
Contributor III

Linechart Display by Qtr Only

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.

1 Solution

Accepted Solutions

Re: Linechart Display by Qtr Only

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())

Capture.PNG

View solution in original post

3 Replies

Re: Linechart Display by Qtr Only

May be this

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

Capture.PNG

Highlighted
gerrycastellino
Contributor III

Re: Linechart Display by Qtr Only

Sunny:

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

Re: Linechart Display by Qtr Only

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())

Capture.PNG

View solution in original post