Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month-1 & Only(Month)-1

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

Unable to understand. Please help on this.

Labels (1)
3 Replies
Anil_Babu_Samineni
MVP
MVP

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()

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar
MVP
MVP

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

avinashelite
MVP
MVP

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