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

Alternate states syntax

Hi,

Could someone explain me the following syntax from the examples in getting started QV11?

num(Sum({[Group 1]<[Product Sub Group]=, Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} Sales)/1000, '#,##0')


and the corresponding one for the alternate state is

num(Sum({[Group 2]<[Product Sub Group]=, Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} Sales)/1000, '#,##0')

10 Replies
Anonymous
Not applicable
Author

paint1.png

I am using following expression to calculate growth%

=Num(((sum({StateB<Year=$ Year,Month=$ Month>} [inv value] / Sales_INR_Unit) -

sum({StateA<Year=$ Year,Month=$ Month>} [inv value] / Sales_INR_Unit)) /

Sum({StateA<Year=$ Year,Month=$ Month>} [inv value] / Sales_INR_Unit) * 100),'#,##0.0')


But i am not getting the result.

I want to calculate growth% on basis of current selection ie(if users select 2016 as year from 1st multibox) and (if user selects 2017 as year from 2nd multibox) then growth% should be calculated on basis of user selection. I have also maintained state for three different Multi Boxes ie StateA(for 1st Miltibox ), StateB(for 2nd Multibox) and StateC(for #rd multibox)