Lookup Function in Set Analysis

[dleelearn]

My current selection is JUN2024 and i would like to have a new column 'NEW ORDER NO' by showing all result as 7.

Any way I can do ?

[dleelearn]

 

[theoat · Accepted solution]

what is your function to calculate the new order No?

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[dleelearn]

No function is set, that is only for illustration purpose.

[theoat]

If you want that the measure is calculated on all month, you can try this (for the case where we count the number of order in each month) :
count({<MONTHYEAR =>}distinct OrderId)

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.