1 Reply Latest reply: Apr 28, 2015 8:17 PM by Shivendoo Kumar RSS

    Change Fields Dynamically in Listbox based on user selected value in Inputbox?

    Shivendoo Kumar

      Hi,

      When I try to browse my data It is always showing records which are completed. It is not showing record which are not yet completed.

       

      How I have designed my dashboard is by Creating a Input box named as Date Type and hardcoded 2 values Created Date and completed Date in dropdown list.

       

      Now selected a list box and used below expression to get Created year and completed Year.

       

      =IF(vDateType='Created Date',[Created Year],[Completed Year])

       

      Same way to get Created and completed Quarter, Month and Day of month

       

      So when I select Date Type Created Date from dropdown then my dashboard should display data for Created year, Quarter, month and Day.

       

      When Date Type Completed Date from dropdown then my dashboard should display data for Completed year, Quarter, month and Day.

       

      But It is not working as expected.

       

      Data Explanation:

       

      Order Count by Created Date on 26th Apri-2015 is 143

      Order Count by Completed Date on 26th Apri-2015 is 56

       

      If I select Date Type=Created Date

       

      and then select Year=2015, Month=Apr Day=26, 27

       

      I am getting count 56 but I am expecting 143

       

      If you see current selection box: It is displaying Created Year=2015 and Completed Year=2015 but I have selected just Created Year, not Completed Year.

       

      If I clear Completed related selection from current selection box then I am getting count 143.

       

      Please find sample QVW at below link

       

      How to handle Null Value in QlikView Star Schema Model? and dealing with 2 dates Created Date and Completed Date

       

      Message was edited by: Shivendoo Kumar