Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
laylagirl
Contributor III
Contributor III

Help with Set analysis ! Help !

Please see attached qvw. Unable to attach app : too big

I have columns 2016, 2017 on table

Right now column 2016 shows 2016 values  and 2017 shows 2017 values.

What is the expression so then user selects 2017 - only shows values from 2016 ?

Prior year

This is the expression :num( ($(vFXImpactvsPY)) *(vDivider),MoneyFormat)  in table for column 2017

This is the expression : num( ($(vFXImpactvsPY2)) *(vDivider),MoneyFormat) in table for column 2016

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

SUM({<Year = {'$(=Max(Year)-1)'}>}YourField)

View solution in original post

4 Replies
MK_QSL
MVP
MVP

SUM({<Year = {'$(=Max(Year)-1)'}>}YourField)

View solution in original post

laylagirl
Contributor III
Contributor III
Author

Here is the problem - the 2017 - half of are zero values.

Do you need 2 complete sets of data to perform set analysis ?

Due to the  dimension being an expression being a variable inside a variable in this case : $(vFXImpactvsPY)

$(vFXImpactvsPY)  is not being recognized as a dimension.   Returns 0  or '-'


MK_QSL
MVP
MVP

Not sure what is $(vFXImpactvsPY)

You have to provide sample data / sample app to work.

laylagirl
Contributor III
Contributor III
Author

It's too big to load.

What do you think of using the Only ()

Since 2 of those expressions are the same I can use the second on to fill 2017 column with 2016 values.

The problem is since 2017 - is all zero from Apr - Dec

When I use that expression it does not return prior year value from Apr -Dec