I have got a tricky requirement. Can somebody know the way out?
On my Qlikview dashboard there is a list box which is used to accept user input for MONTH. User is allowed to select multiple values at same time. However, logically It is correct in case of MTD value and not in case of YTD values(there is another list box to give choice between MTD & YTD).
Now I thought of a solution here, to have 2 list boxes for month. One for MTD and another for YTD. One which is for YTD will allow to have only one value selected at a time. Visibility of both will be dependent on selected value in MTD/YTD list box.
The only difficulty I see in this is to clear selection of other List box while one is active. Say MTD list box wont filter out the data and will be hidden / inactive when YTD is selected.
If somebody has got any other way to achieve same result... please share those as well.