topic Re: Questions in QlikView

Questions

deepakqlikview_123 — Thu, 24 Apr 2014 16:54:43 GMT

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

Re: Questions

MK_QSL — Thu, 24 Apr 2014 17:01:33 GMT

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

Re: Questions

maxgro — Thu, 24 Apr 2014 17:03:19 GMT

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 )

Re: Questions

hic — Thu, 24 Apr 2014 20:20:26 GMT

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