topic Re: Show only 0 for one field.. in QlikView

Show only 0 for one field..

bharatkishore — Mon, 30 Oct 2017 07:16:06 GMT

Hi All,

I have a one dimension called Cat and an expression which shows the values:

In the category i have 8 fields :

cat

a)0 to 1 year

b)1 to 2 year

c)2 to 3 year

d)3 to 4 year

e)4 to 5 year

f)5 to 6 year

g)6 to 7 year

h)More than 7 year

In this i have More than 7 year column only for this i want value to be 0.. Please see the below image for reference:

Here i have value with 12,745 but i want value should be 0 always what ever filters i make.

Please let me know if you require anything more..

Attached app for reference

tresB — Mon, 30 Oct 2017 07:26:31 GMT

Try exp like:

If(cat='h)More than 7 year', 0, Sum({<MonthYear="$(=Date(MonthStart(YearEnd(Max(MonthYear),-1)),'MM/DD/YYYY'))"}>} IB))

pradosh_thakur — Mon, 30 Oct 2017 07:29:32 GMT

please find the attached.

regards

Pradosh

bharatkishore — Mon, 30 Oct 2017 07:33:34 GMT

Thanks Tresesco. i missed (cat='h). I have given

if(cat='More than 7 year', 0, Sum({<MonthYear="$(=Date(MonthStart(YearEnd(Max(MonthYear),-1)),'MM/DD/YYYY'))"}>} IB)).

That is where i missed..Thanks again.

bharatkishore — Mon, 30 Oct 2017 07:34:17 GMT

Thanks Pradosh..

vinayakg — Mon, 30 Oct 2017 07:35:39 GMT

Hi Bharat,

Please Check the attachment