Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing little weird behavior in qliksense w.r.t qlikview expression.
Let me explain in detail
1: My Source data
2 :
my load script is like below in qliksense (similar in qlikview)
[Sheet2]:
LOAD [Year],
[Sales],
Right(Year,2)-1&'-'&Right(Year,2) as Fin_Year
FROM [lib://Desktop/Book1.xlsx]
(ooxml, embedded labels, table is Sheet2);
3:
For PY YTD my set analysis expression is
=Sum({<Year={"$(=max(Year)-1)"}>}Sales)
4.1 : In QlikView
When User Select value from Fin_Year It is showing correct PY YTD
For Example : If User select 16-17, Text object return 100
Working as expected
When User select value from Year from Year field then it is showing correct PY YTD
For Example : If User select 2017, Text object return 100
4.2 : QlikSense
When User Select value from Fin_Year It is showing 0
For Example : If User select 16-17, Text object return 0
Not Working as expected.
Can some one help me to understand this behavior.
gwassenaar, swuehl, mbaeyens, kaushik.solanki
Regards,
My data and script is same which I have posted in my original post.
I left my office and tomorrow if required I will share my both qvf and qvw file.
Sorry for late reply.
I saw below observation.
1: If i create fin_year field in script then in QlikView as well as Qliksense we required to apply logic which you suggest.
2: but if create list box using expression then in qlikview
=Sum({<Year={"$(=max(Year)-1)"}>}Sales) this expresion work
but not in qliksense.
find attachment for your reference.
