topic Re: Based on input values expression in QlikView

Based on input values expression

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

Hello ,

i have a requirement like user will give value and year based on those values i need to calculate condition like in that particular year if the sum(filed) is <=that user input value then i have to show sum(field) else 0.now i want to know how this can be achieved,

till now i have tried like i created two variables and added in input box now user can able to give values.using that variables how to built expression.please help on same .i am new to qlik view.

thanks in advance

kavitha

Re: Based on input values expression

vishsaggi — Thu, 02 Aug 2018 14:17:39 GMT

May be this?

= Sum(If(Year = vYear and Field <= vValue, Field, 0))

Re: Based on input values expression

kavitha_kommise — Fri, 03 Aug 2018 06:59:03 GMT

i have used below expression.finally got the solution.

=if(sum({<YEAR={$(Vdate)}>[field])<=vvar,

sum({<YEAR={$(Vdate)}>}[field),0)

thanks for help

thanks and regards

kavitha.

Re: Based on input values expression

vishsaggi — Fri, 03 Aug 2018 09:58:10 GMT

OK can you close the thread marking yours correct and any helpful responses.

‌

Re: Based on input values expression

kavitha_kommise — Mon, 06 Aug 2018 06:20:07 GMT

hello,

user requirement has changed and that is i have a drill down year and month and then date.

so now user will give a input value. if filed is lesser than 0r equal to a input value then it has to show sum(field) and if it is a greater than it has to show till equal to a input field after coming months sum has to show as 0.

how can i achieve this please help on same.

thanks and regards,

kavitha

Re: Based on input values expression

vishsaggi — Mon, 06 Aug 2018 12:45:12 GMT

Can you share some sample data and with your expected output?

Re: Based on input values expression

kavitha_kommise — Mon, 06 Aug 2018 13:59:14 GMT

i have a sample data like

field date

12000 01-01-2018

20000 01-02-2018

15000 01-03-2018

10000 01-04-2018

10000 01-01-2017

12000 01-01-2017

20000 01-02-2017

15000 01-03-2017

i have drill down for year ,month,and then date

now,

if user input value(IP)=40000

then it has to show nearest value of 40000 after coming months it has to show 0

for this sample data

for 2018 --sum(filed)=57000

2017---57000

if user selection is 40000

then it has to show for year drill down 40,000 and month drill down it has to show till march then coming months zero.like that based on input value it has to work like that.

user will give year and some input value will give based on that it has to work.

if user input value(IP) is greater than sum(field) then below condition will satisfy.

=if(sum({<YEAR={$(Vdate)}>}[field])<=vvar,

num(sum({<YEAR={$(Vdate)}>}[field]),'###,##.##'),0.0)

for above senario what can be achieved please help on same.

thanks in advance,

kavitha