Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Blunck-TotalFitouts
Contributor III
Contributor III

YTD by month

Hi all,

Within a pivot chart (see screen shot attached) I am using the following expression to show a conversion % per month for the 2020/2021 FY:

Count({$<[QuoteData.QuoteSiteConversion]={'Yes'},QuoteData.FYear={'2020/2021'}>} distinct [QuoteData.Quote])
/
count({$<QuoteData.FYear={'2020/2021'}>}distinct [QuoteData.Quote])

This works perfectly.

I now need to create a new expression, that shows the YTD conversion % as the months continue into the 2020/2021 FY.  Tried the following but not getting any luck.

RangeCount(Above(Total Count({$<[QuoteData.QuoteSiteConversion]={'Yes'},[QuoteData.FYear]={'2020/2021'}>} distinct [QuoteData.Quote]), 0, [QuoteData.fMonth]))
/
RangeCount(Above(Total Count({$<[QuoteData.FYear]={'2020/2021'}>} distinct [QuoteData.Quote]), 0, [QuoteData.fMonth]))

Would appreciate some help with this!

Cheers

Carl

1 Solution

Accepted Solutions
Blunck-TotalFitouts
Contributor III
Contributor III
Author

Thanks both, this worked in the end 🙂

(RangeSum(Before(Total Count({$<[QuoteData.QuoteSiteConversion]={'Yes'},[QuoteData.FYear]={'2020/2021'}>} distinct [QuoteData.Quote]), 0, [QuoteData.fMonth])))
/
(RangeSum(Before(Total Count({$<[QuoteData.FYear]={'2020/2021'}>} distinct [QuoteData.Quote]), 0, [QuoteData.fMonth])))

View solution in original post

3 Replies
Anil_Babu_Samineni

@Blunck-TotalFitouts Instead of RangeCount, You can use RangeSum like

RangeSum(Above(Count({$<[QuoteData.QuoteSiteConversion]={'Yes'},QuoteData.FYear={'2020/2021'}>} distinct [QuoteData.Quote])
/
count({$<QuoteData.FYear={'2020/2021'}>}distinct [QuoteData.Quote]), 0,Rowno(TOTAL)))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
talebmakrani
Contributor II
Contributor II

Use “before “instead of “above “

Blunck-TotalFitouts
Contributor III
Contributor III
Author

Thanks both, this worked in the end 🙂

(RangeSum(Before(Total Count({$<[QuoteData.QuoteSiteConversion]={'Yes'},[QuoteData.FYear]={'2020/2021'}>} distinct [QuoteData.Quote]), 0, [QuoteData.fMonth])))
/
(RangeSum(Before(Total Count({$<[QuoteData.FYear]={'2020/2021'}>} distinct [QuoteData.Quote]), 0, [QuoteData.fMonth])))

View solution in original post