Questions

[deepakqlikview_123]

Hello All,

I have questions as per below,

Does circular reference give faulty results??

How does aggregate functions help in QV??

Can more than two parameters be included in mapping table??

Please suggest.

Thanks

[MK_QSL]

Does circular reference give faulty results??

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

How does aggregate functions help in QV??

Aggregate function

Can more than two parameters be included in mapping table??

Applymap

[maxgro · Accepted solution]

circular reference

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

aggregate

QlikView Technical Brief - AGGR.docx

mapping: no you can't

(from online help):

The mapping prefix is used to create a mapping table that can be used for e.g. replacing field values and field names during the script run.

It can be put in front of a Load or Select (SQL) statement and will store the result of the loading statement as a mapping table. A mapping table consists of two columns, the first containing comparison values and the second containing the desired mapping values. Mapping tables are stored temporarily in the memory and dropped automatically after the script execution.

The content of the mapping table can be accessed using e.g. the map … using statement, the rename field statement, the Applymap() function or the Mapsubstring() function.

The syntax is:

mapping ( loadstatement |selectstatement )

[hic]

Circular references:

Read more on the blog post on Circular References

Aggregation functions:

The Aggr() function is not an aggregation function. Read more about aggregation functions like Sum() and Count() on It’s all Aggregations. Read more about the Aggr() function on AGGR....

Multi-paramater mapping table:

Yes, it is possible: How-To: Multi-field ApplyMap

HIC