Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
in one of the requirement I have to fix the dimension in pivot table like if someone select filter the dimension then all the dimension still there only expression filter out for example
suppose we I have 10 dimension and 1 expression in pivot and if someone select 2 dimension I then expression shows the amount for that selected dimension and rest eight dimensions values show nothing but not disappears .
currently what happened if i select some dimension Qlik filter out on the basis of selection and rest all dimension will disappear .
please help me how I can achieve this requirement
Thanks in advance
Sample application and the desired output will help us understand and provide suggestions to your query , so request you to provide the same