Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I view the QS example , and i found out that it use below expression for plot the chart.
Consummer goods KPI :-
(sum([YTD Sales Amount])-sum([LY YTD Sales Amount])*0.2)/sum([LY YTD Sales Amount])
Sales Rep Performance - sales rep variance :-
if((sum([YTD Sales Amount])-sum([LY YTD Sales Amount]))/sum([LY YTD Sales Amount])>-0.45, (sum([YTD Sales Amount])-sum([LY YTD Sales Amount]))/sum([LY YTD Sales Amount]), 0 )
Executive Deskboard - KPI :-
Sum({<[Fiscal Year]={$(=vYTDYear)}, FiscalMonthNum={"<=$(vCurrentMonthNum)"}>}[Sales Price]*[Sales Quantity])/Sum({<[Fiscal Year]={$(=(vYTDYear)-1)}, FiscalMonthNum={"<=$(vCurrentMonthNum)"}>}[Sales Price]*[Sales Quantity])
Executive Deskboard - CY vs LY :-
Sum({<[Fiscal Year]={$(=(vCurrentYear)-1)}>}[Sales Amount])
Performance Deskboard - Sales Variance
(sum([YTD Sales Amount])-sum([LY YTD Sales Amount]))/sum([LY YTD Sales Amount])
Performance Deskboard - Sales comparison :-
Sum([YTD Sales Amount])
Base on above finding , i can conclude that i should not using SET anaylsis when in QS design. instead i should make use of Flag CY or CYTD.
money(
Sum (if($(ColumnDim3), $(ColumnDim51)/$(Columndim89))/1000)
, $(vMoneyFormatK))
$(ColumnDim3) allow make select between CY or CYTD
May i know how can i implement in QS. As QS does not allow me create variable in setting.
Enclsoed my QV sample.
Paul
You might want to post this in the QlikSense forum instead as you'll get more chance of a reply and it'll be more useful when searching for answers in future.
Hi sir
Yes , I forgotten and posted on the wrong section. Thank you for info me.
Paul