Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Problem on data visualization

Dear value community,

I have a problem on the visulization of a data in a simple chart.

I want to display as dimension only the customer with an Invoice in the last 7 days, I made this formula as calculated dimension:

=if([Invoice Date]>Today()-7, [Customer n])

As Expression, I want to see the Invoice value of total year 2019.

sum({$<[Invoice year]={'2019'}>} [Invoice value] )

The problem that occur is that the expression display only the Invoice value of the last 7 days, not of the total year.

How can I fix the formulas?

Many thanks

Andrea

 

 

 

1 Solution

Accepted Solutions
Highlighted
Master
Master

Hi Andrea,

if I understood correctly: you want to display for each customer: the sum of the [Invoice value] for the year 2019

so for dimension: OK

 

=if([Invoice Date]>Today()-7, [customer])

 

 

for Expression I propose :

 

=sum(aggr(sum({$<[Invoice year]={'2019'}>}  [Invoice value]),customer) )

 

 

I did the test on the data source:

 

LOAD * INLINE [
    customer, Invoice Date,Invoice year, Invoice value
    1, 01/12/2018,2018, 100
    2, 31/10/2019,2019 ,200
    3, 27/11/2019,2019, 300
    4, 28/11/2019,2019, 400
    4, 29/11/2019,2019, 250
    4, 29/11/2018,2018, 150
];

 

 

and the results:

datt.PNG

 

Regards,

 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

4 Replies
Highlighted

Hi,

 

take the Dimension as Customer

and u can add your calculated expression into Set analysis

i mean [Invoice Date]>Today()-7 add this also into your set analysis.

Highlighted

Move the customer selection from the dimension to the set expression, Something like this:

sum({$<
    [Invoice year] = {'2019'},
    [Customer n] = P({<[Invoice Date] = {"$(=Date(Today() - 7))"}>} [Customer n])
>} [Invoice value])

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Master
Master

Hi Andrea,

if I understood correctly: you want to display for each customer: the sum of the [Invoice value] for the year 2019

so for dimension: OK

 

=if([Invoice Date]>Today()-7, [customer])

 

 

for Expression I propose :

 

=sum(aggr(sum({$<[Invoice year]={'2019'}>}  [Invoice value]),customer) )

 

 

I did the test on the data source:

 

LOAD * INLINE [
    customer, Invoice Date,Invoice year, Invoice value
    1, 01/12/2018,2018, 100
    2, 31/10/2019,2019 ,200
    3, 27/11/2019,2019, 300
    4, 28/11/2019,2019, 400
    4, 29/11/2019,2019, 250
    4, 29/11/2018,2018, 150
];

 

 

and the results:

datt.PNG

 

Regards,

 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Highlighted
Contributor III
Contributor III

Thank you Taoufiq ,

 

You understood correctly. Your answer is solved my problem.

 

Best regards

 

Andrea