topic Re: show selected dimension in QlikView

show selected dimension

jduluc12 — Tue, 18 Jul 2017 04:38:10 GMT

Hi,

My data set looks like this

Cust date amount

a 01/02/2017 10

b 02/06/2017 20

c 06/17/2017 40

d 05/17/2017 30

I need to write a dimension which shows the customer only when today-date <= 30.

that means if today is 7/17/2017 then only 'c' should appear with its amount.

Re: show selected dimension

Tue, 18 Jul 2017 04:54:05 GMT

1:
load * Inline [

Cust , date , amount,A

a , 01/02/2017 , 10

b, 02/06/2017 , 20

c, 06/17/2017 , 40

d , 05/17/2017 , 30

];

load
Cust,
Today()-date(date#(date,'MM/DD/YYYY'),'DD/MM/YYYY') AS DIFFERENCE,
date(date#(date,'MM/DD/YYYY'),'DD/MM/YYYY') AS date,
amount
Resident 1;
drop Table 1;

AND

use calculated dimendion in chart like this

=IF(DIFFERENCE <=31,Cust)

sum(amount) as expression

Re: show selected dimension

prma7799 — Tue, 18 Jul 2017 04:58:29 GMT

Like this ???