topic Re: Display different sum in QlikView

Display different sum

boopeshj — Sat, 16 Nov 2024 03:10:35 GMT

I have to total a sales value. One expression should show sales based on the selection of the year.

Other one should always show a particular year.

eg: Sum(<{Year={2015}><year={2015}>}Sales) -- This value should always show for 2015</year={2015}>

Sum(Sales) -- This should change according to my Year Selection.

Currently when I select any year except 2015 the expression 1 returns 0.

Any help is much appreciated.

Re: Display different sum

dplr-rn — Wed, 26 Jun 2019 14:30:51 GMT

Whats the issue you are facing? Please elaborate

Seems like you answered your question with the 2 expressions

Re: Display different sum

boopeshj — Wed, 26 Jun 2019 14:53:01 GMT

Thanks Dilip. I have added some more details.

Re: Display different sum

dplr-rn — Wed, 26 Jun 2019 14:59:28 GMT

still confused.

Sum({<{Year={'2015'}>}Sales) should return 2015 data always regardless of what year you select.

How do you want to display it? Is it a KPI? or 2 KPIs

do you want to display 2015 if nothing is selected but the year if something is selected?

Re: Display different sum

boopeshj — Thu, 27 Jun 2019 05:57:08 GMT

It is acatually a Table.

Sales 1 should change according to the year selection.

Sales 2 should always show 2015.

Dim 1 , Dim 2 , Sales 1 , Sales 2

there are other dim conditions in my KPI as well.

Re: Display different sum

dplr-rn — Thu, 27 Jun 2019 13:26:35 GMT

Same expressions should work unless you have date fields as a dimension. if you have date fields you may need to use total qualifier

https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990

Share what dimensions that you are using and i maybe able to help.

Re: Display different sum

boopeshj — Mon, 01 Jul 2019 12:27:05 GMT

Actually Year was taken as an example.

I am using a Dimension field which has multiple values.

Snapshot (Field name)

Current

Jan 2019

Feb 2019

Mar 2019

So I am trying to have 2 expressions

1) Sum({<Snapshot={'Current'}, Dim1={'Value'}>} Sales)

2) Sum({<Dim1={'Value'}>}Sales)

So in this when I select Snapshot from list box Feb 2019 then expression 1 should should sum of sales for current and expression 2 should show sales for Feb 2019.

Thanks Dilip for your time.