Change multiple KPI using one date filter

Anonymous — Wed, 13 Jul 2016 07:44:11 GMT

Hi,

I want to change two KPI using a Date filter(date1) having date id as (date_id).

I have two KPI:

1. #Activated Users

2. #Transacted Users

On applying date filter, I want to see count of users who activated on that date in "Activated Users" kpi and count of users transacted on that date in "Transacted Users" kpi. I have activated_date for a user in user dimension table and transaction_date in fact table.

I am doing this using set analysis:

For Activated User count:

count(distinct {$<date_id= {"$(=activated_date_id)"}>}user_id

For Transacted User count:

count(distinct {$<date_id= {"$(=transacted_date_id)"}>}user_id

By this way, I am getting value of both kpi for a particular date. But these kpi shows "-" when I select multiple date from Date filter. I think comparison in set analysis is failing since I have selected multiple dates.

How do i get KPI values for multiple date ?
I there something like WHERE IN in SQL which i can use to do this?

Re: Change multiple KPI using one date filter

marcus_sommer — Wed, 13 Jul 2016 08:30:15 GMT

Try: count(distinct {$<date_id= p(activated_date_id)>}user_id)

- Marcus

Re: Change multiple KPI using one date filter

Anonymous — Thu, 14 Jul 2016 07:13:45 GMT

Thanks Marcus.

topic Re: Change multiple KPI using one date filter in QlikView

Change multiple KPI using one date filter

Re: Change multiple KPI using one date filter

Re: Change multiple KPI using one date filter