topic Data does not display for One value in QlikView

Data does not display for One value

Anonymous — Tue, 08 Mar 2016 19:23:49 GMT

Can someone help in figuring out why data does not display for just one Group-Function Value in the attached application?

Thank you

Re: Data does not display for One value

m_woolf — Tue, 08 Mar 2016 19:55:39 GMT

Using TP50 as an example, you have used the only function. If you restrict the date to 9/9/2015, there are multiple values for TP50. Therefore only returns null.

Re: Data does not display for One value

settu_periasamy — Wed, 09 Mar 2016 02:58:00 GMT

Hi,

Only function will retrun Null, if there Multiple value. as already said by mwoolf‌

May be you can try with sum instead of Only(). Like

Sum({<ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}TP50)

Re: Data does not display for One value

jagan — Wed, 09 Mar 2016 03:44:15 GMT

HI,

Only() will return value if you have only one value, if you have multiple values then you have to use Sum() or Avg() depending on your requirement.

Regards,

jagan.