topic Re: Month-1 & Only(Month)-1 in QlikView

Month-1 & Only(Month)-1

Wed, 25 Nov 2020 16:16:04 GMT

if Month-1 & Only(Month)-1 gives same output then why we required Only function.

Unable to understand. Please help on this.

Re: Month-1 & Only(Month)-1

Anil_Babu_Samineni — Wed, 08 Mar 2017 13:22:17 GMT

Assume, If you want to show only single year of month

Only({<Year = {'2016'}>}Month)-1 // it will give only 2016 months.

How to use - Only()

Re: Month-1 & Only(Month)-1

sunny_talwar — Wed, 08 Mar 2017 13:24:21 GMT

At time we need to use set analysis and you cannot use set analysis without a function. So, in those cases where you need to use set analysis (for instance you want to ignore selection in field A1, Only({<A1>} Month) - 1), you will need to use Only() rather then just the field name by itself

Re: Month-1 & Only(Month)-1

avinashelite — Wed, 08 Mar 2017 13:27:04 GMT

Check this Doc

How to use - Only()

Use of ONLY Function

Only will return if the dim has a single value in it ..other than that

Month-1 // we cannot implement the set analysis

Only({<>}Month)-1 // we can implement the set analysis