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

saivina2920 — Fri, 15 Nov 2024 23:18:30 GMT

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)

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

QFabian — Mon, 18 Jan 2021 13:05:33 GMT

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)))

topic Re: How do we get count in text label from chart straight table in qlikview in QlikView

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

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