Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Sum({<Ignore_Dimension_1,Ignore_Dimension_2,Ignore_Dimension_3>}Sales)
Your '1' inside sum will ignore all selections. You need to specify what you want to ignore in the set analysis.
How can I ignore dimensions in setanalysis
Sum({<Ignore_Dimension_1,Ignore_Dimension_2,Ignore_Dimension_3>}Sales)
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')