Create calculated fields for table box.

[Anonymous]

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

[v_iyyappan]

Hi,

    Can  attach a sample QV file.

Iyyappan

[Anonymous]

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.

[Anonymous · Accepted solution]

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