topic Re: need hell in writing expression in QlikView

need hell in writing expression

kunkumnaveen — Tue, 15 Mar 2016 09:16:40 GMT

Hello All,

my requirement is i need to display current , previous score and there respective quarters for all the location..

to achieve this i took bar chart

dimension: location,quarter

expression:current score: FirstSortedValue(OVERALL_SCR,-ADATE)

previous score:FirstSortedValue(OVERALL_SCR,-ADATE,2)

by writing this i am getting messed up bar chart (slide 1)

later i replace the expression:

current score:Sum({<ADATE={"$(=max(ADATE))"},YEAR=,QUATERS=,name1=,ENSTEHDAT=>}OVERALL_SCR)

pervious score:Sum({<ADATE={"$(=max(ADATE),2)"},YEAR=,QUATERS=,name1=,ENSTEHDAT=>}OVERALL_SCR)

i got some wired out put (slide 2)...

last time by writing the second expression(sum()) and adding two dimension it worked out perfectly ,but only thing was see the location fields last time it was only a single field but now it is a common key field,is that because the sum() expression is not work?

please help in writhing down proper expression...

Re: need hell in writing expression

sunny_talwar — Tue, 15 Mar 2016 09:19:04 GMT

Would it be possible to share your qvw?

Re: need hell in writing expression

kunkumnaveen — Tue, 15 Mar 2016 09:45:58 GMT

sorry for the delay reply

i am trying to attach my qvw which is about 12mb,from lst 20 min

but unfortunately all the time it throwing me error

i think it not possible to attach

is there any other way sunny

Re: need hell in writing expression

amayuresh — Tue, 15 Mar 2016 09:51:06 GMT

Try this in Bar chart,

Dimesion: EmployeeID ,quarter

Expression:

Current Year =sum(Sales)

Previous Year= sum({1<OrderYear={"$(=Max(OrderYear)-1)"}>}Sales)

Re: need hell in writing expression

Kushal_Chawda — Tue, 15 Mar 2016 09:55:14 GMT

Please reduce the data and try to minimize the size of the application so that it will get attached.

Re: need hell in writing expression

kunkumnaveen — Tue, 15 Mar 2016 10:05:32 GMT

will u please suggest me in writing expression

because i tried even by reducing data ,still its not letting me

Re: need hell in writing expression

kunkumnaveen — Tue, 15 Mar 2016 10:31:53 GMT

hello ,finally i reduced the file size

Re: need hell in writing expression

kunkumnaveen — Tue, 15 Mar 2016 10:32:29 GMT

hello

please find my attachment