topic Re: Need logic help.. in QlikView

Need logic help..

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

Hi,

In attached data I want to show employee growth over in line chart.

With full accumulation and with full data it is showing correct result.

But by default I want to show only data of Max year. in this case value is coming wrong.

Please help me out asap..

Getting Result.

Expected result on without any selection.

Regards,

Lalit Kumar

Clever_Anjos — Wed, 20 Jul 2016 17:53:54 GMT

Use Set Analysis

COUNT({<Year={"$(=Max(Year))"}>} your value)

maxgro — Wed, 20 Jul 2016 18:50:48 GMT

look at the attachement

lalitkgehlot89 — Thu, 21 Jul 2016 04:25:10 GMT

Hi Maxgro,

Data which was given to you was with accumulation.

Please find the attached data without accumulation.

I want to show Employee growth over MonthYear and without any selection it should be show Max Year data.

Regards,

Lalit kumar

er_mohit — Thu, 21 Jul 2016 04:57:55 GMT

PFA.

Hope it helps.

susovan — Thu, 21 Jul 2016 06:17:12 GMT

Hi lalit,

Its might be work,

Sum({<Year={"$(=Max(Year))"}>}Your Value)

yadhunandhanan — Thu, 21 Jul 2016 06:28:57 GMT

Hi Lalit,

Use this Expression,

if(GetSelectedCount(Year)=0,Max({$<Year={"$(=Max(Year))"}>}WORKER),Max(WORKER))

Hope it helps.