topic Re: Set Analysis-calculated value that should not change on selection in QlikView

Set Analysis-calculated value that should not change on selection

amit_shetty78 — Wed, 08 Jan 2014 12:15:20 GMT

Hi All,

I need to show some values like:

User Logged in Today:

User Logged in Yesterday:

.....

and these values will no change when any selection is made in the document.

My table People has fields:

UserID Last_Login LASTLOGGEDINDATE_Num

1 8-Jan-2014 41647

2 8-Jan-2014 41647

3 7-Jan-2014 41646

an so on.

I need to show a table like following when the document is loaded. User will be clicking on any of the other fields but these values should not change.

Logged in Today: 2

I have set up a variable: v_current_date_num=num(today())

and using this variable in the following calculation: count({$< People.LASTLOGGEDINDATE_Num={'=$(v_current_date_num)'}>} UserID).

This does not seem to work as the value this shows depends on what date is selected.

appreciate any help on this.

thanks.

Re: Set Analysis-calculated value that should not change on selection

swuehl — Wed, 08 Jan 2014 12:20:50 GMT

Maybe without the single quotes and equal sign and with set identifier 1

count({1< People.LASTLOGGEDINDATE_Num={$(v_current_date_num)}>} UserID)

Re: Set Analysis-calculated value that should not change on selection

manideep78 — Wed, 08 Jan 2014 12:24:46 GMT

Try this in your expression

=Count({1<FieldName={'$(VariableName)'}>}UserID)

In your Case:

=count({1< People.LASTLOGGEDINDATE_Num={'$(v_current_date_num)'}>} UserID)

Hope this helps

Regards,

Manideep

Re: Set Analysis-calculated value that should not change on selection

amit_shetty78 — Wed, 08 Jan 2014 12:26:35 GMT

Thanks Swuehl. That works.