topic Re: Hi Friends in QlikView

Hi Friends

Wed, 25 Nov 2020 16:16:04 GMT

I have a list box with the Year:2004,2005,2006,2007,2008,2010.

but when i select the list box any range of years which means 2005 to 2007 (Or) 2004 to 2008 i need total selected years of sum(sales)

using set analysis can any one help on this.

Regards,

Siva

Re: Hi Friends

Anil_Babu_Samineni — Sun, 19 Feb 2017 12:20:24 GMT

Set analysis has that future, No need to create for that

From here, If you select any thing either 2005 - 2007 then Sum(Sales) shows the 2005, 2006 & 2007 Data only. Same with 2004 - 2008

Simple use this -- Sum(Sales)

Sum(TOTAL Sales)

Re: Hi Friends

surendraj — Sun, 19 Feb 2017 12:30:39 GMT

Sum({$}Sales)

Re: Hi Friends

Sun, 19 Feb 2017 12:31:51 GMT

Hi Anil,

For Create a visualization hwre user has to "From Year" and "To Year". A text box should show a message as follows

for example From year 2004 and To year is 2007 the sales between the year of 2004 and 2007

Here is my question

Hope you understand

Thank you vary much

Re: Hi Friends

surendraj — Sun, 19 Feb 2017 13:07:07 GMT

In text box try this..

='For ' & GetFieldSelections(Year,'|') & 'Sale is ' & sum(sale)

='For ' & GetFieldSelections(Year,'|') & 'Sale is ' & sum({$}sale)

You can use your delimiter as ,(coma) or pipe...

Re: Hi Friends

Kushal_Chawda — Sun, 19 Feb 2017 13:44:14 GMT

in year selection box, provide search option. Click on search and type >=2007 <= 2009 (Make sure that year field is not text) and hit enter. All year in that range will get selected.

Re: Hi Friends

surendraj — Sun, 19 Feb 2017 13:50:07 GMT

Try with this...its working fine compared to my previous expression..

='The sales between the Year of' & Chr(39) & SubField(GetFieldSelections(year,'|'),'|') & Chr(39) & 'To Year' & Chr(39) & SubField(GetFieldSelections(year,'|'),'|',GetSelectedCount(year)) &'='&sum(sale)

Re: Hi Friends

vinieme12 — Sun, 19 Feb 2017 15:19:10 GMT

a simpler Expression would be

=if(GetSelectedCount(Year)>1,'Sales From' & Min(Year) &' to ' & max(Year) & ' is : ') & Sum(Sales)

Re: Hi Friends

Anil_Babu_Samineni — Sun, 19 Feb 2017 15:36:50 GMT

Vineeth Solution Should work

Still you are looking

='Sales Between the Year of ' & Min(Year) & ' And ' & Max(Year) & ' Is ' & Sum(Sales)

If solve your issue as you expected, Then close the Thread by flag of Correct answer

Re: Hi Friends

muthukumar77 — Mon, 20 Feb 2017 07:54:36 GMT

Hi,

create 2 varibles ,

vFromYear and vToYear

assign,

vFromYear = 2004

vToYear= 2008

expression,

=sum({<Year={">=$(vFromYear)"},Year={"<=$(vToYear)"}>}Sales)