topic Re: need help with chart expression and set analysis in QlikView

need help with chart expression and set analysis

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

Hi All ,

Attached QVW file has all the information in it. Please let me know in case of any questions. Thanks for your help

Re: need help with chart expression and set analysis

Anonymous — Wed, 14 Dec 2016 21:50:44 GMT

pfa

Re: need help with chart expression and set analysis

sunny_talwar — Wed, 14 Dec 2016 23:31:35 GMT

Do you have to use a straight table or a pivot table might also work?

Re: need help with chart expression and set analysis

sunny_talwar — Wed, 14 Dec 2016 23:37:05 GMT

Straight table solution

Sum(Aggr(If(vDocumentDate - [Due Date] < 1, Sum({$<[Document Date_BLDAT]={'<=$(vDocumentDate)'}, Clearing_AUGDT={'>$(vDocumentDate)'}>} [Amount in LC_DMBTR])), [Document Number_BELNR], [Document Date_BLDAT], [Due Date], Clearing_AUGDT))

Re: need help with chart expression and set analysis

sunny_talwar — Wed, 14 Dec 2016 23:42:32 GMT

Here is a pivot table based solution

Re: need help with chart expression and set analysis

Anonymous — Thu, 15 Dec 2016 12:13:49 GMT

Sunny need in pivot table what is the expression

Re: need help with chart expression and set analysis

sunny_talwar — Thu, 15 Dec 2016 12:21:17 GMT

Dimension

=month(vDocumentDate)

=Aggr(

If(vDocumentDate - [Due Date] < 1, Dual('Current', 1),

If(vDocumentDate - [Due Date] >= 1 and vDocumentDate - [Due Date] <= 30, Dual('1 - 30', 2),

If(vDocumentDate - [Due Date] >= 31 and vDocumentDate - [Due Date] <= 60, Dual('31 - 60', 3),

If(vDocumentDate - [Due Date] >= 61 and vDocumentDate - [Due Date] <= 90, Dual('61 - 90', 4), Dual('Over 90', 5))))), [Document Number_BELNR], [Document Date_BLDAT], [Due Date], Clearing_AUGDT)

Expression

Sum({$<[Document Date_BLDAT]={'<=$(vDocumentDate)'}, Clearing_AUGDT={'>$(vDocumentDate)'}>} [Amount in LC_DMBTR] )

Re: need help with chart expression and set analysis

Anonymous — Thu, 15 Dec 2016 12:26:11 GMT

thank you Sunny. That definitely helps.

Re: need help with chart expression and set analysis

sunny_talwar — Thu, 15 Dec 2016 12:26:43 GMT

Awesome

Re: need help with chart expression and set analysis

Anonymous — Thu, 15 Dec 2016 16:31:47 GMT

Sunny a small change in the request. Let me know if i have to do a separate post

if i have this DATE field which will have month end dates in case of the vDocumentDate variable. How can i get the expression get to work for each month. See the attached app you will have more information.

Re: need help with chart expression and set analysis

sunny_talwar — Thu, 15 Dec 2016 16:35:39 GMT

Checking

Re: need help with chart expression and set analysis

sunny_talwar — Thu, 15 Dec 2016 16:42:17 GMT

Are you looking for this?