Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
d_koti24
Creator II
Creator II

Regarding date selection issue

Hi All,

I have table like this:

periodsales
01/07/2015100
01/08/201580
01/09/2015120

my requirement is :

if i select 01/08/2015 in period ,i want to show the sales difference between 08/2015 ,07/2015 in text object.

ex: in text obj i want show the diff :100-80 =20

if i select 1/09/2015, in text obj i want show the diff :120-80 =40

if i select 1/07/2015 ,i don't have previous month so i want to show 100.

How to achive this?

Regards,

dk

4 Replies
rubenmarin

Hi dk, can you try this?;

Sum({<period={'$(=Max(period))'}>} sales) - Sum({<period={'$(=AddMonths(Max(period), -1))'}>} sales)

I set the first part as Max(period) in case there aremore than one possible period value in the selections. Maybe you need to use Date() to assign the date format.

Gysbert_Wassenaar

Try Sum(sales)-Sum({<period={"=$(date(monthstart(max(period),-1),'MM/DD/YYYY'))"}>}sales)

If that doesn't work make sure that period is a date field and not a text field. Use the date#() function in the script if necessary to turn text values into date.


talk is cheap, supply exceeds demand
effinty2112
Master
Master

In a straight table as this expression

sum(sales)-Above(sum(sales))

This will give null for the first row but if you really want the first row to show sum(sales for the difference use:

if(RowNo()=1, sum(sales), sum(sales)-Above(sum(sales)))

Cheers

HirisH_V7
Master
Master

Hi,

Variables:

vDate=Date(Max(Date),'DD/MM/YYYY')

vDate2=Date(MonthStart(Max(Date),-1),'DD/MM/YYYY')


In Text Box:


(Sum({<Date={"$(vDate)"}>}Sales) -Sum({<Date={"$(vDate2)"}>}Sales))

Based on Selection.PNG

PFA

Hope this Helps,

Regards,

Hirish

HirisH
“Aspire to Inspire before we Expire!”