topic Re: Set Analysis without Aggregation in TextBox in QlikView

Set Analysis without Aggregation in TextBox

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

Hello All,

I have a data table in below format

From the above table i'm looking to have two text boxes for each Product showing the differnce in Value versus Last year.

Text Box 1: 4.13

Text Box 2: -5.80

If i use the Sum in Set Analysis it gives me a completely wrong value. Please, help me in getting this without any AGgregation function.

TIA!!

sunny_talwar — Fri, 25 May 2018 11:26:23 GMT

How can you use set analysis without using any Aggregation? You will need to use Sum, Avg, Only to use set analysis... try this

Test Box 1

Sum({<Year = {'2018'}, Product = {'N1'}>}Value) - Sum({<Year = {'2017'}, Product = {'N1'}>}Value)

Test Box 2

Sum({<Year = {'2018'}, Product = {'N2'}>}Value) - Sum({<Year = {'2017'}, Product = {'N2'}>}Value)

vijetas42 — Fri, 25 May 2018 11:28:26 GMT

do you want to show difference between values for year 2018 and 2017 for each product in text box?

shiveshsingh — Fri, 25 May 2018 11:51:58 GMT

Do you mean to get the desired results without SUM( Aggr func)? It's not possible i guess.

psk180590 — Fri, 25 May 2018 12:00:18 GMT

I used Only to get my desired result

psk180590 — Fri, 25 May 2018 12:00:27 GMT

Thanks all.