topic [HELP] set analysis going wrong, please help.. in QlikView

[HELP] set analysis going wrong, please help..

Mon, 27 Sep 2010 07:13:06 GMT

hello..

i wanna to show the last 6 days value

so i use this set analyst :

Sum ({<RowNo={"<=$(=max(RowNo))>$(=RowNo(max(RowNo)-6))"}>}

i use RowNo so when there is a null value in any certain date, it will show the previous day

but the problem is, i only able to show the 6 last days value if i click on one of RowNo field

when i click on date, it only shows the date that i click

so what suppose i do to make it right?

i mean, when i click one of date, it will show last 6 days base on RowNo

please help me..

i'm really stuck and i'm really a noob..

i've attached the file so maybe it will help u to help me

many many thx...

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0081.6-days-test.rar:550:0]

[HELP] set analysis going wrong, please help..

jonathandienst — Mon, 27 Sep 2010 07:20:26 GMT

Your attached file is section access protected so I can't open it.

You may need to override the date selection in your set expression. If the date field is called TrDate, then:

Sum ({<TrDate=,RowNo={"<=$(=max(RowNo))>$(=RowNo(max(RowNo)-6))"}>}

should do the trick.

(I am assuming that RowNo is a field that is linked in some way to date. If you are trying to use the RowNo() function, then you cannot use it this way in a set expression).

Jonathan

[HELP] set analysis going wrong, please help..

Mon, 27 Sep 2010 07:33:49 GMT

hello Jo..

it worked..

but it isnt possible when i try to add more then 1 dimension for the syntax, it wont work

i also have year,month,date

when i try to click it for certain date from year,month,date list box, it still show only 1 date

but when i click on one of date from mst_date listbox, it shows last 6 days value

how to do it Jon?

i've attached the file again

thx..

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/8308.6-days-test.zip:550:0]

[HELP] set analysis going wrong, please help..

jonathandienst — Mon, 27 Sep 2010 08:09:37 GMT

Still can't open your qvw as it is section access protected.

I am not sure that I understand your question, but if you need to override the selection of other fields as well, you can say:

Sum ({<TrDate=,TrMonth=,TrYear=,RowNo={"<=$(=max(RowNo))>$(=RowNo(max(RowNo)-6))"}>}

Or you can ignore selections completely by starting the expression with

Sum ({1<RowNo={"<=$(=max(RowNo))>$(=RowNo(max(RowNo)-6))"}>}

Jonathan

[HELP] set analysis going wrong, please help..

Tue, 28 Sep 2010 02:21:44 GMT

hello Jon..

it worked

this is really what i want

thx Jon...