QS handling set analysis differently to QV

Oggy172 — Tue, 14 Jan 2025 16:23:22 GMT

Hi,

I'm trying to migrate some reports (charts) from QV to QS.

On one, a median price list file, I have strange behaviour in QS.

I have a table, and when I add in any measure, I lose all results in the table - but on QV it works fine, I'm just trying a lift & shift.

With just the 3 dimensions, I get data (too much) - but when I add *any* of the 3 measures, it returns only a singular 'null' row.

~~With it being our pricing, it's not data I can really share - but hoping someone can see where it's going wrong.~~

I've attached some fake files to aid with this

Start Date:

min({<PL_Products.BlockedP={'N'},[Unit of Measure CodePL]={'*'}-{'FOC'},PL_Disc={'P'},PL_Item={'*'}-{'SSS'},[Start Date]= {"<=$(=min(PL_Startdate))"},[End Date]= {">=$(=min(PL_Enddate))"}>}[Start Date])

End Date:

max({<PL_Products.BlockedP={'N'},[Unit of Measure CodePL]={'*'}-{'FOC'},PL_Disc={'P'},PL_Item={'*'}-{'SSS'},[Start Date]= {"<=$(=min(PL_Startdate))"},[End Date]= {">=$(=min(PL_Enddate))"}>}[End Date])

Median Price

median({<PL_Products.BlockedP={'N'},[Unit of Measure CodePL]={'*'}-{'FOC'},PL_Disc={'P'},PL_Item={'*'}-{'SSS'},[Start Date]= {"<=$(=min(PL_Startdate))"},[End Date]= {">=$(=min(PL_Enddate))"}>}[PriceList Unit Price])

QS is the same

Re: QS handling set analysis differently to QV

Oggy172 — Tue, 14 Jan 2025 14:54:27 GMT

Expanded calculation QS:

Re: QS handling set analysis differently to QV

MatthewSmith — Tue, 14 Jan 2025 16:22:26 GMT

Try replacing '*' with "*"

Re: QS handling set analysis differently to QV

Oggy172 — Tue, 14 Jan 2025 16:25:52 GMT

Hi @MatthewSmith

That appears to have fixed it, in that I get data - I will check over it's validity tomorrow - thank you so much!

topic Re: QS handling set analysis differently to QV in App Development

QS handling set analysis differently to QV

Re: QS handling set analysis differently to QV

Re: QS handling set analysis differently to QV

Re: QS handling set analysis differently to QV