topic For each... Next.... in QlikView

For each... Next....

Dayna — Tue, 02 Feb 2010 14:48:46 GMT

Hello,

Is it possible, for the function 'For each'... to use it for expressions within a chart, and if so, how would I go about it?

I.e. for each site do sum(balance) next...

Your help is appreciated!

Kind Regards,
Dayna

For each... Next....

disqr_rm — Tue, 02 Feb 2010 15:37:24 GMT

I don't think it is possible.

Any way it would create performance issues. I would rather make adjustments in the script - introduce new flags, etc. to do sum on the charts. If you provide your data model details, we can make some suggestions for you. Other options would be to use <GROUP> with sum or aggr() functions.

Thanks

For each... Next....

Dayna — Tue, 02 Feb 2010 17:14:01 GMT

Hello Rakesh,

Many thanks for the response, currently my data is a combination of two QVD's, to provide a balance field and the site which the balance is related to.

The expression I am currently using within my chart is:


firstsortedvalue(DISTINCT aggr(min({<[BOM Chart - Date] = {"<=$(=date(only(today())+91))>=$(=date(only(today())-91))"}>} [BOM Chart - Balance]),[BOM Chart - Timescale],[BOM Chart - AutoNo]),-[BOM Chart - AutoNo])

If you could advise or need any more information, please let me know!

Kind Regards,
Dayna