topic Re: how to write analysis in QlikView

how to write analysis

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: how to write analysis

ramasaisaksoft — Wed, 30 Nov 2016 06:54:22 GMT

Hi Siva,

2nd answer is Number only .

Re: how to write analysis

Anil_Babu_Samineni — Wed, 30 Nov 2016 06:59:16 GMT

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)

Re: how to write analysis

Anonymous — Wed, 30 Nov 2016 07:01:12 GMT

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.

Re: how to write analysis

Anonymous — Wed, 30 Nov 2016 07:07:50 GMT

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.

Re: how to write analysis

MindaugasBacius — Wed, 30 Nov 2016 07:13:52 GMT

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.

Re: how to write analysis

Wed, 30 Nov 2016 07:26:35 GMT

Thanks Anil for your quick replay,

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