Hi,
I have a table in QLik Sense and when I select a 'Proc_id' from the dimension's drop sown list, the associated value is listed in the below pivot table.
I am using this expression: -
if(date(ALERT_CREATE_DATE) > Date('$(vDATE_ALERT)' - '$(vRANGE_ALERT)') and date(ALERT_CREATE_DATE) <=Date('$(vDATE_ALERT)'), date(ALERT_CREATE_DATE)) in the 'Alert Date' field and all the rows in the table is coming according to the expression, but when I search the Proc_id from the drop down, I found that all the proc_id is coming instead of satisfying the condition. SO is there any problem in the dimension listing?
![](/legacyfs/online/192294_pastedImage_2.png)
and the second thing is when I select proc_id from the list, the values associated to it coming in the below table:-
![](/legacyfs/online/192295_pastedImage_4.png)
and we are using the below expression to show the value in it:-
=if(GetSelectedCount(PROC_ID_TRAN)='0' and GetSelectedCount(ALERT_ID_TRAN)='0','-',text(PROC_ID_TRAN))
but when I use an expression :-
if(date(ALERT_CREATE_DATE) > Date('$(vDATE_ALERT)' - '$(vRANGE_ALERT)')
and date(ALERT_CREATE_DATE) <=Date('$(vDATE_ALERT)'), PROC_ID_TRAN))
then if(GetSelectedCount(PROC_ID_TRAN)='0' and GetSelectedCount(ALERT_ID_TRAN)='0','-',text(PROC_ID_TRAN)) is not working for me.