topic Re: Please Help Me in QlikView

Please Help Me

rajveersinghsisodiya — Wed, 09 Jul 2014 12:06:07 GMT

hi i need to create some table or chart like specified below:-

Field NAme	Avg	Stdev
Name_of_field_1	10.2	2.5
Name_of_field_2	15.76	4.6
Name_of_field_3	16.56	5.6

all this feilds are from one table.

Re: Please Help Me

Wed, 09 Jul 2014 12:09:23 GMT

Do u have avg and stDev available or u want to calculate it.

What is the problem you are facing in creating above table

Re: Please Help Me

alexandros17 — Wed, 09 Jul 2014 12:11:25 GMT

Load

[Field Name],

stdev(myField) as StandardDeviation ,

avg((myField) as average

from abc.xlsx group by [Field Name];

let me know

Re: Please Help Me

Wed, 09 Jul 2014 12:11:28 GMT

If u have already calculated then simply u can use table box

Re: Please Help Me

avinashelite — Wed, 09 Jul 2014 12:11:56 GMT

Hi Rajveer,

Use Straight table Chart, in dimension give your field name and in expression write Avg(filed name)

and add second expression , definition as Stdev(filed name)

Re: Please Help Me

Gysbert_Wassenaar — Wed, 09 Jul 2014 12:12:35 GMT

Create a calculated dimension:

=valuelist('Name_of_field_1','Name_of_field_2','Name_of_field_3')

and two expressions:

pick(match(valuelist('Name_of_field_1','Name_of_field_2','Name_of_field_3'),'Name_of_field_1','Name_of_field_2','Name_of_field_3'), avg( Name_of_field_1),avg( Name_of_field_2),avg( Name_of_field_3))
pick(match(valuelist('Name_of_field_1','Name_of_field_2','Name_of_field_3'),'Name_of_field_1','Name_of_field_2','Name_of_field_3'), stdev( Name_of_field_1),stdev( Name_of_field_2),stdev( Name_of_field_3))

Re: Please Help Me

rajveersinghsisodiya — Wed, 09 Jul 2014 12:15:27 GMT

it not calculated i need to calculte it.

Re: Please Help Me

rajveersinghsisodiya — Wed, 09 Jul 2014 12:16:46 GMT

data is already loaded and i need to calculate it with writing expressions.

Re: Please Help Me

avinashelite — Wed, 09 Jul 2014 12:18:30 GMT

Can you please post your qvw file

Re: Please Help Me

Wed, 09 Jul 2014 12:19:20 GMT

use straight table

Dimension - FieldName

Expression - Avg(Field)

Expression2-stdev(Field)

Re: Please Help Me

alexandros17 — Wed, 09 Jul 2014 12:21:58 GMT

So use field name as dimension and two expressions:

avg(myValue)

stDev(myValue)

Re: Please Help Me

rajveersinghsisodiya — Wed, 09 Jul 2014 12:24:06 GMT

thanku so much Gysbert Wassenaar

it working.

Re: Please Help Me

rajveersinghsisodiya — Wed, 09 Jul 2014 12:45:50 GMT

hi Gysbert Wassenaar one more problem in this table, only one field should be seen when it get selected from list box.

Re: Please Help Me

Gysbert_Wassenaar — Wed, 09 Jul 2014 13:22:30 GMT

If you have a listbox with field names then you either have or can create a field with the field names. You can use that field, e.g. FieldNames, as dimension and change the expression to

pick(match(FieldNames, $(=Concat(chr(39) & '[' & FieldNames & ']' & chr(39) ,','))),

$(=concat( 'avg('[' & FieldNames & '])', ','))

)

Re: Please Help Me

rajveersinghsisodiya — Thu, 10 Jul 2014 05:29:55 GMT

hi Gysbert Wassenaar its not working.

i will explain the scenario. i have one list box in that values are

Name_of_field1
Name_of_field2
Name_of_field3

and i have one table in that i need to show Avg and Stdev of one selected value from above list box.