How do we get count in text label from chart straight table in qlikview

[saivina2920]

How do we get count in text label from chart straight table in qlikview.

I have the below dimensions and expression in my chart straight table and it contains the sum of total of every expressions.

the same sum of total expressions, i just want to display in my separate text object.

Is it possible to do this..?

Table Dimensions

=If(vUserInput, if(IsNull(EMP_RELIEVE_DATE) AND [EMP_STATE]='$(vEmPlaces)', EMP_RESIGN_DATE), if(not IsNull(EMP_RELIEVE_DATE) AND [EMP_STATE]='$(vEmPlaces)', EMP_RELIEVE_DATE))

Exp1 : "Relieving_Date"

=If(vUserInput, if(IsNull([EMP_RELIEVE_DATE]) AND [EMP_STATE]='$(vEmPlaces)', Date(EMP_RESIGN_DATE+vUserInput)), if(not IsNull([EMP_RELIEVE_DATE]) AND [EMP_STATE]='$(vEmPlaces)', EMP_RELIEVE_DATE))

Exp2 : 1-10days

if([Relieving_Date]>=vCalDate10 And [Relieving_Date]<=vToday AND [EMP_STATE]='$(vEmPlaces)',1,0)

[QFabian · Accepted solution]

Hi @saivina2920 , you can put your expressions in text boxes, but you have to be sure if there is a aggregation needed.

For example, your expressions doesnt have a SUM or COUNT or any valid aggregation, so, if there is mote than one record/row involved in your selections, that expression isnt goinf to work.

just add a sum or  count for chechink that

=sum/count(If(vUserInput, if(IsNull([EMP_RELIEVE_DATE]) AND [EMP_STATE]='$(vEmPlaces)', Date(EMP_RESIGN_DATE+vUserInput)), if(not IsNull([EMP_RELIEVE_DATE]) AND [EMP_STATE]='$(vEmPlaces)', EMP_RELIEVE_DATE)))