Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

problem in stdev

Hi All,

In attached app when i was selecting only single value in "MonthYear" listbox, then in straight table chart "Stdev" expression is getting '-' value.

How i can resolve this issue and should get the value instead of '-'?

please provide your suggestion on this from anyone

Regards,

Satish

1 Reply
Anonymous
Not applicable
Author

Hi Satish,

the fact is that RangeStdev of a single value is zero, or rather is not calculated, cause the value is equal to its avg.

I think you'd like to see '0' rather than '-'... well, I would do it brutally: if(rowno()=1,0,expr).

Greetings

IB