topic Re: showing latest value in textbox in QlikView

showing latest value in textbox

Fri, 03 May 2013 04:16:59 GMT

AOA

I hava a bar chart showing month wise inventory in stock....

say

jan 186799

feb 195335

mar 20227

apr 25354

now i want to shw a current month inventory in text box.... which is APR where MONTH is dimension name....

and expression is =sum({<stock-={0}>}bal_amount)

kinldy advice:

sivarajs — Fri, 03 May 2013 04:53:22 GMT

use this expression

sum({<Month_No={"$(=max(Month_No))"}>}Amt)

Month_No you can get using following expression else you can use month also

date(Date#(Date,'DD-MMM-YYYY'),'MM')

Fri, 03 May 2013 05:04:19 GMT

try this

sum({<month={"$(=max(date(month,'MMM')))"}>}Amt)

er_mohit — Fri, 03 May 2013 05:09:58 GMT

sum({<Month={$(=month(today()))}>}bal_amount)

Fri, 03 May 2013 08:25:31 GMT

jan 186799

feb 195335

mar 20227

apr 25354

thnks to all of you who replied unfortunatly my month dimension is not a date function

its hardcoded table

time id month year

1 jan 2013

2 feb 2013

3 mar 2013

4 apr 2013

i have reload the data on 31 apr so APRIL become the latest month.

i also have a field of max_month which giving current month i.e APR

my query is (select sum(bal_amt) where month=max_max_month) in text box

so all your replies are not working because no date involve in my sheet..

and also i dont want maximum value of amount to display i want latest

mean (max_month) value.. which is 25354

thnks

if u guys can help