topic Re: Explain the difference in QlikView

Explain the difference

eromiyasimon — Wed, 25 Nov 2020 16:16:04 GMT

Explain the difference between these two expression

sum(Sales)

sum({<[Vendor Name]=,[Dept Name]=>}Sales)

Re: Explain the difference

HirisH_V7 — Mon, 02 Jan 2017 06:10:31 GMT

There the selections for [Vendor Name]=,[Dept Name] will not reflect the chart or report.If you use that expression.

For restricting the selections for some particular fields, we will include them in the set analysis expressions.Like above.

Re: Explain the difference

Anil_Babu_Samineni — Mon, 02 Jan 2017 06:13:32 GMT

There is no diff for these, Second one is only for Filter / Sorting for specific

Assume, If you used these 2 expression it won't effect. And if you can go and use filter like below and then check. that is the case they were sort to filter for specific Vendor

sum({<[Vendor Name]={'MagnaInfotech'},[Dept Name]=>}Sales)

Re: Explain the difference

kumarkp412 — Mon, 02 Jan 2017 06:15:21 GMT

Hi Simon,

In the first expression, it will give the sum of sales and also it gives the result with a respective selection also.

i.e for supposing you are the sum sales in pivot table using the first expression.when you make a selection on the filter Vendor Name and DeptName. Based on the selection it will display the values on the table.

In the second expression, it will give the sum of sales and also it won't filter the data when you make a selection on vendor name and DeptName.

i.e for supposing you are the sum sales in pivot table using the first expression.when you make a selection on the filter Vendor Name and DeptName. It will disable the selection of the filter and shows the sum of sales of the all.

Thanks

Kumar