In Qlicksense I want a pivot with the count of month-year in the rows as a dimension:
i selected
=MeseAttivo
in the dimension and it works fine.
In the column I want the count of contracts with a filter which also works fine.
=Count({<DATA_CESSAZIONE_FORNITURA.autoCalendar.MeseAttivo = {"$(=max(DATA_CESSAZIONE_FORNITURA.autoCalendar.YearMonth))"}, FLG_VOLTURA_USCENTE = {'N'} >} DISTINCT CODICE_CONTRATTO)
Then I want the count of the contracts in the following month. So for example, if I have dec-24 as a row I want one column with the count of contracts in dec-24 and the other with the count of contract in jan-25. I really don't know how to write the measure. Please help me!
ps. I'm new in Qlik, be patient!
