Need to show total Value but for All Date, but min Date in Layout

[mhmmd_srf]

Hi All,

I have a requirement like:

I have a Straight Table, where I want to total value for All date. However in the layout I want to show only min Date for each Item.

Idea is that Item should not repeat.

Current output:

Expected output:

I am attaching sample qvw file here.

Please help.

[tresesco]

Remove date field from dimension and use Date(Min(DateField)) in expression instead.

[tresesco]

Note, if you need to get the date range filter as in other expressions, you have to use the same in set analysis as well here like:

Date(Min({<CstDate1 = {'>=$(=$(vMaxDate_30)) <$(=$(vMaxDate))'} >} CstDate1))

[mhmmd_srf]

Hi Tressesco,

I am getting Error in Calculation error.

And second thing , Set expression is already there in expression.

May be I am not getting you properly.

Please help.

Thanks,
Sarif

[tresesco · Accepted solution]

PFA

[mhmmd_srf]

Okk ... got it.. thanks Tresesco...

One more help required bro.

If I remove filter on Category.

it is coming like below:

I want to remove the row, where B/O Units and B/O Dollars are coming 0.

I tried with if condition. But it is showing error in Dimension.

Any other way to implement?

Thanks,

Sarif

[sunny_talwar]

May be change your first expression to this (updating and reposting Tres's qlikview file)

=If(Column(2) <> 0 or Column(3) <> 0, Date(Min({<CstDate1 = {'>=$(=$(vMaxDate_30)) <$(=$(vMaxDate))'} >} CstDate1)))

[tresesco]

For date expression, use condition like:

If([B/O Dollars]<>0 and [B/O Units]<>0,   // You might want to use '>0' if needed.

Date(Min({<CstDate1 = {'>=$(=$(vMaxDate_30)) <$(=$(vMaxDate))'} >} CstDate1))

)

[mhmmd_srf]

Thanks Sunny ... it is working...