topic Default value in selection in QlikView

Default value in selection

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

Good Morning Everyone,

Today while working in a Dashboard I got the requirement to make the text box value by default 0 ( zero ).

When I select any month it will give the value for that respective month only.

In Short, I am not in need to populate Cumulative Numbers.

1) Text Box

2) Expression : =If(GetSelectedCount(Month)=0,0,Count(GID3))

but the expression is not working ...

Re: Default value in selection

settu_periasamy — Tue, 20 Jun 2017 03:41:02 GMT

Hi,

you already got the '0' value in your text box when there is no selection, right?

how do you want that?

Re: Default value in selection

Anonymous — Tue, 20 Jun 2017 03:43:01 GMT

Thanks for reply Settu,

But when I select any month, even I get 0 (zero).

Re: Default value in selection

devarasu07 — Tue, 20 Jun 2017 03:46:20 GMT

Hi,

Refer to the attachment, can you share your mock app? Tks

Re: Default value in selection

settu_periasamy — Tue, 20 Jun 2017 04:05:36 GMT

Can you try to separate the expression and put into two text box?

GetSelectedCount(Month) - what it is showing when you select the Month?

Count(GID3) - what is the count?

Re: Default value in selection

Anil_Babu_Samineni — Tue, 20 Jun 2017 04:15:24 GMT

Your expression condition seems working because When we are not selecting any thing from Month it will return 0 then Condition. Will you able to do with Count(GID3) then show us the Value after selecting the Month which is returning value. then will look into

Re: Default value in selection

Anonymous — Tue, 20 Jun 2017 04:54:51 GMT

Yes I got the answer,

My Script was this.

LOAD GID as GID3,

Month as Month1,

Year as Year1

FROM

but in Expression, I used Month which supposes to be Month1