Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to apply VARIABLE $(ColumnDim3) in QS ?

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

2 Replies
thornofcrowns
Valued Contributor II

Re: How to apply VARIABLE $(ColumnDim3) in QS ?

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.

paulyeo11
Valued Contributor II

Re: How to apply VARIABLE $(ColumnDim3) in QS ?

Hi sir

Yes , I forgotten and posted on the wrong section. Thank you for info me.

Paul

Community Browser