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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to write analysis

Hi Friends,

How to write set analysis for between 3 months data ,

what is diff b/w  today() and today()-1 it get number or date.

interview questions?

6 Replies
ramasaisaksoft

Hi Siva,

2nd answer is Number only .

Anil_Babu_Samineni

Hope helps

1) Sum({<Month = {"$(=AddMonths(Month, -3))"}>}Sales)

This Will give last 3 months of Sales

2) Today() Will give Today's date of your Computer calendar & Today()-1 is Yesterdays date of your computer calendar (It returns Date for Today and Number for Today-1)

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
Anonymous
Not applicable
Author

hi,

today() is going to print today date like 30-11-2016

today()-1 is going to print number,if you apply date(today()-1) it will brings the yesterday date.

Anonymous
Not applicable
Author

It will helps you to get 3 months data

sum({<Your Date filed={">=$(=AddMonths(Today(),-3)) <=$(=Today())"}>}Sales)

this expression brings data from 3 months back to today.

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

It'll calculate the sum of Hours where Data > 2016-08-30:

=SUM(

{<

  Date={">$(=Date(AddMonths(today(),-3), 'DD/MM/YYYY'))"}

>}

Hour)



The date is a dual functions. It contains numeric and date values.

Not applicable
Author

Thanks Anil for your quick replay,

Could you help me on set analysis , i have lot of doubts , if you have time