Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
tgumbing
Contributor III
Contributor III

Need help set analysis

Hello,

I have a Table where I have to calculate per month a expression based on different date.

The dimension:
=AQMP.MONTH

The expression:
count(DISTINCT {<AQMP.YEAR={$(=Max(AQMP.YEAR))}, AQMP.MONTH={"<=$(=Max(AQMP.MONTH))"}>} [AQMP.N° AQMP])
/
count(DISTINCT {<AQMP.YEAR=, AQMP.MONTH=, TSF.YEAR={$(=Max(AQMP.YEAR))}, TSF.MONTH={"$(=only(AQMP.MOIS))"}>} TSF.Product)


In the second calculation I need to calculate for each month from the dimension the TSF.Product. And the Table TSF doesn't have the same calendar. And it must be aggregate per month from dimension AQMP.MONTH

 

Labels (1)
0 Replies