Discussion Board for collaboration related to QlikView App Development.
Please advise if doable:
- Input : Two tables – Calendar, Facts
- Objective : Create a Pivot-Table chart with a Time Dimension (Year/Quarter/Month) and two expressions:
- I could NOT figure out how to set the second expression utilizing Set-Analysis. Is it doable ?
- Please see attached QVW.
once try this
You can't use set analysis. The set is calculated per chart, not per dimension value. Try this instead:
Hi Prem Kumar,
Thanks for your reply. It seems to be working ONLY when the Time dimension is Month (due to the use of the Above() function.) I need to be able to get the previous month above the current row regardless if it is scope(Year, Quarter, or Month).
Thanks for your reply. This doesn't seem to be working.. I need to get the monthly amount right above the row I'm in (regardless if the time-dimension being used is Year, Quarter, or month)
Works for me. You said you wanted "Amount of LAST month above the current row (regardless if the Dimension is Year, Quarter or month)".
That's exactly what the expression does.If you want sum(Amount) for the previous Year if the dimension is Year then you need another expression. The easiest is to use above(sum(Amount))