topic Re: How to Exclude date from my KPI Set analysis in QlikView

How to Exclude date from my KPI Set analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hi Gurus,

I am new to Qlik, I have business requirement in sales dash board below:

Showing YTD & pre YTD, MTD& Prve Month MTD, WTD & Prev Week WTD, I got these KPI's, the problem is if user select any store, product, category geographic dimension it would be change as per user selection. If user select any dates (year, month, quarter, week , day) this would not change bcz it is all calculated on date range in KPI .

I used below set analysis to get these KPI's:

YTD calucuation:=Num(Sum({1<ShippedDate={">=$(=YearStart(Max({1}ShippedDate)))<=$(=YearEnd(Max({1}ShippedDate)))"}>} SalePrice),'#,##0')

Please help me out on the same.

Re: How to Exclude date from my KPI Set analysis

vkish16161 — Wed, 18 Oct 2017 18:57:38 GMT

Your '1' inside sum will ignore all selections. You need to specify what you want to ignore in the set analysis.

Re: How to Exclude date from my KPI Set analysis

Wed, 18 Oct 2017 19:18:04 GMT

How can I ignore dimensions in setanalysis

Re: How to Exclude date from my KPI Set analysis

vkish16161 — Wed, 18 Oct 2017 20:43:49 GMT

Sum({<Ignore_Dimension_1,Ignore_Dimension_2,Ignore_Dimension_3>}Sales)

Re: How to Exclude date from my KPI Set analysis

Wed, 18 Oct 2017 21:28:00 GMT

Thank you , I have changed my formula like below and it works as expected:

=Num(Sum({$<YearID=, MonthNumber=, QuarterID=, WeekName=, ShippedDate=, _OrderDate=,_ShippedDate=,ShippedDate={">=$(=YearStart(Max({1}ShippedDate)))<=$(=YearEnd(Max({1}ShippedDate)))"}>} SalePrice),'#,##0')