I need to get the Max value and have two set modifiers, I get a value only when I used one modifier but I get null value when I used two:

[hildacgg]

Doesnt work This I get null -

=Max({<PeriodID = {$(=($(vfkPeriod)))},[Fiscal Year]={$(=(($(vfkBWYear))-1))}>} (WeekID))  This I get null -

Here I get a value:

=Max({<[Fiscal Year]={$(=(($(vfkBWYear))-1))}>} (WeekID))

Here I get a value:

=Max({<PeriodID = {$(=($(vfkPeriod)))}}>} (WeekID))

Please Help!!!

[settu_periasamy]

May be like this.

=Max({<PeriodID = {$(=vfkPeriod))},[Fiscal Year]={$(=vfkBWYear)-1}>} WeekID)

or

=Max({<PeriodID = {"$(=vfkPeriod))"},[Fiscal Year]={"$(=vfkBWYear)-1"}>} WeekID)

[Oleg_Troyansky · Accepted solution]

It's hard to estimate with the double $-sign expressions (I assume these are formulas that need to be re-evaluated), however if both expressions are accurate (since they produce results individually), I can only think of one possibility:

Your dataset contains data for the requested Year and for the requested Period, but in a different year. For example:

Year 2014 has Periods 1-12

Year 2015 has periods 1-9

Selecting Period 10 alone will produce the sum of 2014-10. Selecting Year 2015 alone will produce the sum for 2015. Selecting both 2015 and 10 will produce an empty set.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[hildacgg]

Thank you for your answer, I really appreciated.  I was missing one additional modifier.

[hildacgg]

You are right Oleg, that was the problem. Thank you.

[Oleg_Troyansky]

Can you please mark the correct answer, to close the thread? 🙂

[hildacgg]

How do I mark the correct answer?

[hildacgg]

I am going to take advantage that you are an expert and ask you an additional question.

Can I input data into some columns of an uploaded axcel file using qlikview.

I am uploading an excel table with columns: Customer #, Name, Sales Q4-2015, and I have an additional column without data for Budget Q4-2015 to be input for the sales reps. Is this possible?