topic Re: set Analysis in QlikView

set Analysis

Tue, 03 Feb 2015 05:16:19 GMT

Hi to all,

I have the data from 01 Dec 2008 to 03/02/2015...

if we select any date between these dates,,i want get the data from 01/12/2008 to selected date.

i have two fields like Product and opening Quantity.

for opening Quantity i have to find out that in pivot table.

please give me expression for that.

suppose i selected 01 feb 2015, then i will get the data from starting date to selected date means 01 Dec 2008 to 01 feb 2015.

pls help me

Thannks in advance.

chandra.

Re: set Analysis

MayilVahanan — Tue, 03 Feb 2015 05:21:40 GMT

Try like this

= Count({<Date = {"<= Date(Max(Date),'DD/MM/YYYY')"}>} Quantity)

Note:

Please change the date format as per ur date format.

Re: set Analysis

Tue, 03 Feb 2015 05:24:09 GMT

hii mahil,

i want get the data from starting date to selected date

might be not count,,surely it ll be sum

thanks for ur reply

Re: set Analysis

PrashantSangle — Tue, 03 Feb 2015 05:34:15 GMT

Hi,

Try like

= Sum({<Date = {"<=$(=Date(Max(Date),'DD/MM/YYYY'))"}>} Quantity)

Regards

Re: set Analysis

Tue, 03 Feb 2015 05:57:59 GMT

Hi max,

Thanks for ur reply,

I have an one doubt,

is there any need of start date???? if yes how???

i stored my max date into as vEndDate Varible..

how can i use it pls give me proper expression.

Re: set Analysis

PrashantSangle — Tue, 03 Feb 2015 06:17:22 GMT

Hi,

Since you need data from begining to current selection then you dont required the start date in above expression.

It will give you all data less than or equal to current selection date.

Now if you want to used variable then create variable with expression

=Date(max(Date),'DD/MM/YYYY')

Then replace that varible with expression used in set analysis.

Try like

=Sum({<Date={"<=$(vEndDate)"}>}Quantity)

Regards

Re: set Analysis

Tue, 03 Feb 2015 06:26:29 GMT

Hi Chandra,

Define the valuable

vEndDate =Date(Max(Date),'DD-MM-YYYY')

Please try this exp:

Sum({<Date = {"<=$(vEndDate)"}>} Quantity)

Re: set Analysis

avinashelite — Tue, 03 Feb 2015 06:31:24 GMT

Try like this:

1.define a variable to the current selected date

2.Then use if condition to get the required data field

if(Date <= Date(Max(Date),'DD/MM/YYYY'),required_feild}

Re: set Analysis

Tue, 03 Feb 2015 06:36:57 GMT

Thank u so much to all for giving reply..

Generally i have an one doubt to max and sovan,,,

U given expressions right??? in that expression what can i put replacing by ''date'' after sum({....

in my script i ve an one field that is Posting date...

thanks

Re: set Analysis

avinashelite — Tue, 03 Feb 2015 06:41:22 GMT

if you have got the answer mark this tread as answered and close it

Re: set Analysis

Tue, 03 Feb 2015 06:47:49 GMT

ok Avinash

thanq.

Re: set Analysis

Wed, 04 Feb 2015 11:52:23 GMT

Hi to All,

I have the data from 01 Dec 2008 to 03/02/2015... if we select any date between these dates,,i want get the data from 01/12/2008 to selected date.

Above expression is not working pls help me.

I want display data from starting date to Selected date....

I did n't store any dates into variables..

i have my column Posting date,

Pls give me expresion for that...

Thanks for advance

please help me....

Re: set Analysis

avinashelite — Wed, 04 Feb 2015 12:00:26 GMT

Hi,

steps:

if your capturing the current selected date in variable then use this expression:

if(datefeild<=$(vcurrentdate),requiredfeild);

or if your selecting the current date in the list box, then

if(datefeild<=getfeildselection(datefeild),requiredfeild);

if your still facing issue please post your app