topic Re: Value of Set Analysis when no data available in QlikView

Value of Set Analysis when no data available

phil-ebm — Thu, 14 Apr 2016 15:38:43 GMT

Hi @All

During the development of QV-Application I was confused about the SetAnalysis.

Is it possible when the Value in Set Analysis not available in the Datamodel Qlikview ignors this part of the SetAnalysis?

I have a SetAnalysis for the actual Year and the previous Year in a Variable.

vActYear = max(Jahr) = 2017

vPrevYear = vActYear - 1 = 2016 <- 2016 is not available in the datamodel because the data just start in financelYear 2017 and we need time to add the previous years

vSetAnalysisActYear: Geschäftsjahr={$(vActYear)},Monat=,[Geschäftsjahr Bez]=,Jahr=

vSetAnalysisPrevYear: Geschäftsjahr={$(vPrevYear)},Monat=,[Geschäftsjahr Bez]=,Jahr=

and use them in this expressions:

HU Count Actual Year

Count({<$(=vSetAnalysisWareExtern),$(=vSetAnalysisActYear)>}distinct [Extern HU])

HU Count Prev Year

Count({<$(=vSetAnalysisWareExtern),$(=SetAnalysisPrevYear)>}distinct [Extern HU])

The first expression for actual year works fine.

For the second one qlikview shows me the Number of all HUs and not 0 how i excpeted depending on the year.

Can someone help me where i have the error?

The first SetAnalysis-Variable "vSetAnalysisWareExtern" hast no influnece on this topic. I tried it with and without this variable and have the same result.

Regards

Philipp

Re: Value of Set Analysis when no data available

sunny_talwar — Thu, 14 Apr 2016 15:43:08 GMT

In a text box object when you add this -> $(vPrevYear), do you see 2016?

Re: Value of Set Analysis when no data available

phil-ebm — Thu, 14 Apr 2016 15:52:03 GMT

Yes. In a textbox I see the correct Year.

Re: Value of Set Analysis when no data available

sunny_talwar — Thu, 14 Apr 2016 16:01:08 GMT

Not sure I will be able to tell much without look at a sample. Would you be able to provide one?

Re: Value of Set Analysis when no data available

settu_periasamy — Thu, 14 Apr 2016 16:04:07 GMT

is this typo? missed character 'v'..

Count({<$(=vSetAnalysisWareExtern),$(=vSetAnalysisPrevYear)>}distinct [Extern HU])

Re: Value of Set Analysis when no data available

jagan — Thu, 14 Apr 2016 16:05:35 GMT

Hi,

Did you tried this

Count({<$(=vSetAnalysisWareExtern),Geschäftsjahr={$(vPrevYear)},Monat=,[Geschäftsjahr Bez]=,Jahr=>}distinct [Extern HU])

Count({<Geschäftsjahr={$(vPrevYear)},Monat=,[Geschäftsjahr Bez]=,Jahr=>}distinct [Extern HU])

Is this working?

Regards,

Jagan.

Re: Value of Set Analysis when no data available

phil-ebm — Fri, 15 Apr 2016 05:49:40 GMT

Oh i'm ashemd

My colleges and I searched the hole day yesterday and didn't see this small doubt

No everything works fine.

Thanks for your help