topic Re: can any one help me set analysis in QlikView

can any one help me set analysis

Mon, 14 Oct 2013 19:06:56 GMT

sum({$<Date={">=09/01/2012"},Item={'PAN 34g'}>} Units)

i am using this one but not getting any result it is showing me zero value

but when i take out date and sum it for total for ex

=sum({<Item ={'PAN 34g'}>} Units)

thanks in advance

Re: can any one help me set analysis

Clever_Anjos — Mon, 14 Oct 2013 19:11:28 GMT

Please check your Date field format

Re: can any one help me set analysis

rustyfishbones — Mon, 14 Oct 2013 19:14:27 GMT

try this

SUM({$<Date ={"$(=Date('09/01/2012'))"},Item={'PAN 34g'}>} Units)

Re: can any one help me set analysis

Mon, 14 Oct 2013 19:18:47 GMT

thanks for your response but it is not working

Re: can any one help me set analysis

Mon, 14 Oct 2013 19:19:51 GMT

Thank you for your response

date field format is dd/mm/yyyy which i specified in the expression

Re: can any one help me set analysis

Clever_Anjos — Mon, 14 Oct 2013 19:22:07 GMT

Is is possible post a sample of your data?

Re: can any one help me set analysis

rustyfishbones — Mon, 14 Oct 2013 19:22:20 GMT

I am missing < (less than sign), sorry

try this

SUM({$<Date ={"<$(=Date('09/01/2012'))"},Item={'PAN 34g'}>} Units)

Re: can any one help me set analysis

Mon, 14 Oct 2013 19:31:09 GMT

thank you

is is giving me value but i wanted to see >= 9/01/2012 where can we give the greater than condition

Re: can any one help me set analysis

rustyfishbones — Mon, 14 Oct 2013 19:34:48 GMT

Here it is

SUM({$<Date ={">$(=Date('09/01/2012'))"},Item={'PAN 34g'}>} Units)

Re: can any one help me set analysis

rustyfishbones — Mon, 14 Oct 2013 19:35:06 GMT

please mark if correct

Re: can any one help me set analysis

stevedark — Mon, 14 Oct 2013 19:40:31 GMT

Hi there,

This will almost certainly be a problem with the data format. First up, can you check the format your date is presently in. If you add a list box you should see the natural format, also the sort order should show you if it the date is stored as a numeric or as text.

If the date is stored as text then you will need to convert it to a true date field on the way into the document, using a Date# function.

You can force the format of the date field in the load using a Date function, this way you know what format it is you need to match to in Set Analysis.

The format of the date value in the set analysis expression must exactly match that of the natural format of the date in your data model.

If you can upload an example document then I can take a look at it for you.

Regards,

Steve

Re: can any one help me set analysis

stevedark — Mon, 14 Oct 2013 21:05:01 GMT

Sorry to be pedantic - but does the expression Alan has given not require an equals sign to include values that fall on 09/01/2012?

SUM({$<Date ={">=$(=Date('09/01/2012'))"},Item={'PAN 34g'}>} Units)

-Steve

Re: can any one help me set analysis

rustyfishbones — Mon, 14 Oct 2013 21:15:21 GMT

Ha! pedantic Steve, you are probably correct.

I'd trust you before I would trust me

hope the Masters Summit went well