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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

Want to find the StDev value

I have 10 values ​​in Spray field as shown in the figure. I want to find the StDev total of Panel Side = Top side regardless of Axis. In Excel, I would drag the mouse from Spart1 of Axis 1 to Spray1 and then spray10.

Paknanarn23_0-1741334033672.png

What should I do?

2 Replies
Ben_P
Creator II
Creator II

It depends on your data structure, and whether you want the result as a standalone KPI or as part of a table.

You say you have 10 values in the spray field, so I assume the data structure is something like this: 

Ben_P_0-1741365377780.png

In this case, if you want a KPI showing stdev for all Top side values, something like this should work:

if([Panel side]='Top side',stdev(Value))

Paknanarn23
Creator II
Creator II
Author

I want to find all values ​​of Spray 1-10 ignoring Axis.

Paknanarn23_0-1741423733613.png

This is a formula in Excel.