topic Re: with out set analysis in QlikView

with out set analysis

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

Hi experts,

I have 12 months data in db now i want data for 6 th month. how to write the set expression and and how to write the same query by using IF condition

Thanks In advance...

Re: with out set analysis

tresB — Thu, 03 Mar 2016 04:30:41 GMT

Whenever you ask a query here, try to create a sample qvw and share. This helps you get the solution faster, because without that there would be many assumptions and subsequent queries. I.e. - let the people know how your data look like and how exactly the output you are expecting to be. So, try to share a sample qvw.

Re: with out set analysis

prabhas277 — Thu, 03 Mar 2016 04:38:47 GMT

HI,

Sum ({<year = {$(=max (year))}>} [budget amount]) - this is expression for max year right? so now

i want max year by using IF condition instead of set analysis

Re: with out set analysis

settu_periasamy — Thu, 03 Mar 2016 04:44:21 GMT

Then, you can try

If(year = Max(year), true statement, false statment)

Re: with out set analysis

tamilarasu — Thu, 03 Mar 2016 04:47:07 GMT

Hi,

Hope you have date field. You can try with max(date).

Sum({<Date={‘>=$(=Addmonths(Max(Date), -6))<=$(=Date(Max(Date)))’}>} [budget amount])

Re: with out set analysis

tresB — Thu, 03 Mar 2016 04:49:03 GMT

In a text box, try like: Sum ( If(year =$(=max (year)), [budget amount]) )

Re: with out set analysis

jagan — Thu, 03 Mar 2016 05:20:36 GMT

Hi,

Set analysis is the best option for this type of scenarios, it has better performance over using If(). Not sure why you are not using the Set Analysis.

IF you really want then use below expression using Aggr()

Sum ( Aggr(If(year =Max(TOTAL year), Sum([budget amount]), 0), year))

Hope this helps you.

Regards,

jagan.