QS handling set analysis differently to QV

[Oggy172]

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

QV

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

[Oggy172]

Expanded calculation QS:

QV

[MatthewSmith · Accepted solution]

Try replacing '*' with "*" 

[Oggy172]

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!