topic Please help with last year values in QlikView

Please help with last year values

Thu, 19 Feb 2015 11:32:46 GMT

Hello Everyone,

Please help me into the below issue.

I am calculating the Last year values by using attached script, values are coming correct, But

when i am count of days, the day count is coming wrong,

lets say if i have data only for 7 days in Feb 2015, i should get count of days is 7, but my script is showing 28, it means it is for complete month.

Can you please tell me how to avoid this

Thank in advance, your valid reply will be great help to me.

Regards ,

Sreeharsha V

Re: Please help with last year values

Fri, 20 Feb 2015 04:41:17 GMT

Any Luck from anybody

Re: Please help with last year values

jonathandienst — Fri, 20 Feb 2015 05:26:10 GMT

Where are you calculating a day count? I dont see it in your script.

Re: Please help with last year values

Fri, 20 Feb 2015 05:36:14 GMT

Hello Jonathan,

I am calculating day count at application level by using count(Date).

Thanks

Re: Please help with last year values

jonathandienst — Fri, 20 Feb 2015 05:40:33 GMT

Then use a set expression or if expression to only count dates that have values against them

Count(If(Value<>0 , Date))

If you need more help with expressions, provide more information about the data model rather than the load script.

Jonathan

Re: Please help with last year values

Fri, 20 Feb 2015 07:13:16 GMT

Hi Jonathan,

Thanks for the reply, i did it, but my scenario there would be possibility that the measure is having 0 value, i should not skip that day.

i tried like below:

i took one more date in the script without joining the date table, i used that in the set analysis by giving the condition like Date<MaxDate, the values are coming as expected

Thanks for the response

Regards,

Sreeharsha V