topic Create calculated fields for table box. in QlikView

Create calculated fields for table box.

Anonymous — Fri, 02 Mar 2012 06:09:14 GMT

Hi,

I am trying to create a statistics such as MAX, MIN, AVG, SUM, for each selection.

for eg.

You have a field name InstrumentCode in a listbox.

When you click MTN, the statistics for this instrument is displayed in the Table.

Then if you click another Instrument such as VOD then you get its statistics in the table with MTN.

If I use the statistics box in Qlikview it gives me the total of the selections, I need it to be separated.

Kind Regards,

Razak

Create calculated fields for table box.

v_iyyappan — Fri, 02 Mar 2012 06:13:46 GMT

Hi,

Can attach a sample QV file.

Iyyappan

Create calculated fields for table box.

Anonymous — Fri, 02 Mar 2012 06:18:36 GMT

Basically I need to know whether I can seperate Statistics Box in Qlikview or if I can add a calculated column in a Table box, without having to calculate it in a script and then reloading it.

Create calculated fields for table box.

Anonymous — Fri, 02 Mar 2012 07:10:59 GMT

Found an alternate solution, create a Straight Table and then from there calculate all the Statistics.