Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I'm new to Qlikview and am trying to get something I thought was relatively simple but seems bit difficult.please help me to get this.
i have year field(FY)-2016,2017,2018,2019
Variables : vMinyear and vMaxyear
have to calculate Revenue
suppose if i select 2016 output should be 2016 to 2019
if 2017: 2017 ,2018, 2019
2018: 2018 to 2019
i have tried like below
sum({<FY={">=$(vMinyear)<=$(vMaxyear)"}>}Revenue) but it showing selected year only.
same for Quarter
Please let me know how to achieve this via set analysis.
Thanks in Advance.
Chandra
Hi Pradosh,
Variable is done in variable overview as same as we discussed.
but still it is showing single year value.
=sum({<FY={">=$(vMinyear)<=$(vMaxyear)"}>}Revenue)
Thanks,
Chandra
I have attached a sample.
Hi,
Thanks Pardosh .
Its working Fine .Same as like Year i want to create for Quarter.
Thanks you very much.
Chandra
Hi Pardosh,
help me for QTD also
Thanks Chandra
How does your quarter data looks like ?
P.S: Please mark correct answer whichever is appropriate , You can mark helpful comments as well.
Hi Pradosh,
Quarter field is Quarter
Q1,Q2,Q3 and Q4 are the values
above expression :
=sum({<FY={">=$(vMinyear)<=$(vMaxyear)"}>}Revenue) is working fine
but the expression has to give like below
=If(Group='revenue',=sum({<FY={">=$(vMinyear)<=$(vMaxyear)"}>}Revenue),
if(Group='expense',sum({<FY={">=$(vMinyear)<=$(vMaxyear)"}>}Expense))
Above xpression is showing the value for the selected year.
Please help me.
Thanks
Chandra
=If(Group='revenue',sum({<FY={">=$(vMinyear)<=$(vMaxyear)"}>}Revenue), if(Group='expense',sum({<FY={">=$(vMinyear)<=$(vMaxyear)"}>}Expense) ))
Hi Pradosh,
Still, it's Showing the selected year in the report.
PFA below.
Expression Is :
=If(Group='REVENUE_Flash' ,sum({<FY={">=$(vMinyear)<=$(vMaxyear)"},Flag={1}>}Revenue),
if(Group='EXPENSE_GL',sum({<FY={">=$(vMinyear)<=$(vMaxyear)"}>}MORvalue)
))
Thanks,
Chandra
=If(Group='REVENUE_Flash' ,sum({1<FY={">=$(vMinyear)<=$(vMaxyear)"},Flag={1}>}Revenue), if(Group='EXPENSE_GL',sum({1<FY={">=$(vMinyear)<=$(vMaxyear)"}>}MORvalue) ))
Hi Pradosh,
Still, it remains the same with your expression.
Thanks,
Chandra