topic Re: Help with Set analysis ! Help ! in QlikView

Help with Set analysis ! Help !

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

MK_QSL — Sun, 30 Apr 2017 20:12:13 GMT

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

Anonymous — Sun, 30 Apr 2017 20:19:10 GMT

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 — Sun, 30 Apr 2017 20:20:45 GMT

Not sure what is $(vFXImpactvsPY)

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

Anonymous — Sun, 30 Apr 2017 20:25:53 GMT

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