Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

sumitsahu009
Not applicable

Change multiple KPI using one date filter

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?

1 Solution

Accepted Solutions
marcus_sommer
Not applicable

Re: Change multiple KPI using one date filter

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

- Marcus

2 Replies
marcus_sommer
Not applicable

Re: Change multiple KPI using one date filter

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

- Marcus

sumitsahu009
Not applicable

Re: Change multiple KPI using one date filter

Thanks Marcus.