topic Re: IS EXPR CORRECT? in QlikView

IS EXPR CORRECT?

Anonymous — Tue, 14 Oct 2014 10:20:06 GMT

to find out the today used space

=sum({<year={$(=year(today())}>}(usedspace/totalspace)*100)

to find out the yesterday used space

=sum({<year={$(=year(today()-1)}>}(usedspace/totalspace)*100)

i am giving these 2 expressions in bar chart

please tell me these 2 are correct or not ? if not? correct me .

Re: IS EXPR CORRECT?

Tue, 14 Oct 2014 10:27:12 GMT

Hi,

It won't give today's data.it will give this year data

year(today()) means assume today 14/10/2014 so it will give here year=2014 so it will calculate all the 2014 year data it won't calculate today's data

as it is second expression is also give 2013 year whole data it won't give yesterday's data.

expressions are correct as per your requirement it is not give proper result to you.

Re: IS EXPR CORRECT?

PrashantSangle — Tue, 14 Oct 2014 10:29:05 GMT

Hi,

Expression is correct but the purpose for which you are using is wrong

If you comparing Year field with today's Year and Yesterday's Year give you

Sum of same year i.e. 2014

Basically if want to comapare with today and Yestarday, You have to compare with complete dateField

i.e. Your expression like

for Today

=sum({<DateField={$(=Date(today())}>}(usedspace/totalspace))*100

It can be

sum({<DateField={$(=Date(today())}>} usedspace)/Sum({<year={$(=year(today())})>}Total Space)*100

For Yesterday

=sum({<DateField={$(=Date(today()-1)}>}(usedspace/totalspace))*100

Again check Date Format to get correct Output

Regards

Re: IS EXPR CORRECT?

Anonymous — Tue, 14 Oct 2014 10:32:05 GMT

here i have no date field what todo ?

Re: IS EXPR CORRECT?

Tue, 14 Oct 2014 10:34:25 GMT

sorry

you have to mention the today's date like 'datefield = today' and yeasterday's date like 'datefield = today-1'

mention datefield instead of year.

hope this help you.

Re: IS EXPR CORRECT?

Anonymous — Tue, 14 Oct 2014 10:38:50 GMT

Hi malaya,

instead of datefield in above expression what i need to replace

Re: IS EXPR CORRECT?

Tue, 14 Oct 2014 10:43:00 GMT

you have give the datefield in the expression

Re: IS EXPR CORRECT?

Anonymous — Tue, 14 Oct 2014 10:44:22 GMT

i dont have any date field in my data

Re: IS EXPR CORRECT?

jonathandienst — Tue, 14 Oct 2014 10:44:24 GMT

If you have no date field, how do you identify today's records and yesterday's records?

Jonathan

Re: IS EXPR CORRECT?

Anonymous — Tue, 14 Oct 2014 10:46:53 GMT

that is the main problem here .

but once server reloading every day it will create indidual qvd for everday

Re: IS EXPR CORRECT?

PrashantSangle — Tue, 14 Oct 2014 10:51:54 GMT

Hi,

Then in your script use FileBaseName() which returns Filename

from which you have to seperate your datefield and use that datefield in your expression

You can use combination of Subfield() or Date#() to find Date from fileName

Regards

Re: IS EXPR CORRECT?

PrashantSangle — Tue, 14 Oct 2014 10:54:39 GMT

Hi,

You can use FileTime() also to get last Reload Time of that File.

Regards

Re: IS EXPR CORRECT?

Anonymous — Tue, 14 Oct 2014 11:33:22 GMT

can u tell me what is the final expression or instead of date field i have top put filename()

Re: IS EXPR CORRECT?

Anonymous — Tue, 14 Oct 2014 11:42:19 GMT

how to find can u give me expresssion if u dont mine

Re: IS EXPR CORRECT?

PrashantSangle — Tue, 14 Oct 2014 11:57:14 GMT

Hi,

As you said,

once server reloading every day it will create indidual qvd for everday

which means you have qvd for everyday then in your script you have to add

FileTime() which returns your QVD creation Time in Timestamp format.

Then you can use that Creation Time in your expression.

to compare

Modify your script like

load *, FileTime() as FileDate from tableName;

Just add highlighted expression in your field.

I hope you understand the logic.

Regards,