Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I wanted to disable all dimensions selections for only one chart in my sheet of qlik sense whether this is possible in qlik sense ?
vikas
If you have currently e.g. this expression
sum( fieldx x)
you can try this
sum( {1} fieldx x)
The set analysis expression {1} just ignores all selections done by a user.
num(RangeSum( Above(Count( {1} {<COMPANY={'ABCD'}, Created_on_Flr={'>=$(=vCutOffDate3)'}>} Distinct CCNO),0,RowNo())),'##,##,###')
in set analysis i used {1} but no luck , After this still i am able to select the dimensions.
Is there any other way to restrict the selection of dimensions for specific chart ?
Vikas
Please try
num(RangeSum( Above(Count( {1 <COMPANY={'ABCD'}, Created_on_Flr={'>=$(=vCutOffDate3)'}>} Distinct CCNO),0,RowNo())),'##,##,###')