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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Break month sort when trying to add conditional

I have conditional,that if i have last no full month,i must put zero on all rows in table.

I put if on the top quotient(divider) if,like:

    

if(Year=Year(Max(%Date)) and Month=Month(Max(%Date)),0,

Sum({<[Основной поставщик]={'test},FlagThisMonth={1},[Month]=,Year=>}[MySum])

)     //End if

/

Sum(DISTINCT{<[Основной поставщик]={'test'},FlagThisMonth={1},[Month]=,Year=>}

Aggr(NODISTINCT Sum({<[Направление]={'ЛЮКС'},FlagThisMonth={1},[Month]=,Year=>}[MySum]),[Numenclature Group],[Month Year]))

This count aggr quotient by group in pivot table

But,when i select some month,like february - this month becomes first in dimensions.How i can disable this?

Thx for helping

0 Replies