topic Re: Filter data based on selected fields in Set Analysis in QlikView

* Filter data based on selected fields in Set Analysis / Using Indirect Analysis *

IAMDV — Fri, 06 May 2011 11:29:45 GMT

Dear All,

I am working on a survey project. I had data for different activities like...

Travel
Away from Home - Shopping
Away from Home - Entertainment
Away from Home - Eating

I have this data for each hour of the day and each day of the week. Now I wanted to look the behaviour of my audience. I mean I am using a simple set analysis expression to display a bar chart...

COUNT({$<TimeStampValue = {$(=($(vMaxCurrentTime)))} , Q_No ={'Q1'} >} Resp_ID)

Now I wanted to look at the behaviour of the same audience for next & previous hour. So I had created a variable which calculates the previous & next hour based on the time selected by the user. And if the user selects a specific time, day & activity.

For example : Selecting the audience who travel at 7AM on Sunday. And if there are 1000 responses for the same.

*** Now I wanted to see the behaviour of these 1000 respondents in previous hour & next hour? ***

I hope it all makes sense. Your help/suggestions are much appreciated

Many thanks in advance.

Cheers - DV

Re: Filter data based on selected fields in Set Analysis

IAMDV — Fri, 06 May 2011 11:32:05 GMT

Also, I had tried to use indirect analysis. But I can't get it working

I can explain more if you need to know more details...

Cheers - DV

Re: Filter data based on selected fields in Set Analysis

IAMDV — Fri, 06 May 2011 12:12:59 GMT

Adding to my previous post :

I had tried using the Indirect Analysis and can't seem to get the syntax right. Please can someone look into this one...

COUNT(({<TimeStampValue={$(=($(vPreviousHour)))},

Resp_ID = p({<TimeStampValue={$(=($(vCurrentTime)))} Resp_ID>})

Resp_ID)

Thanks - DV

Re: Filter data based on selected fields in Set Analysis

IAMDV — Fri, 06 May 2011 13:30:01 GMT

I had got the syntax right, however it does not filter the data based on current selection. Please can someone look this for me...

COUNT({$<TimeStampValue={$(=($(vNextHour)))},

Q_No = {'Q1'},

Resp_ID = p({$<TimeStampValue={$(=($(vCurrentTime)))}>} Resp_ID)>}

Resp_ID)

This expression with Indirect Set Analysis returns zero . Which is incorrect...

Thanks - DV

Re: Filter data based on selected fields in Set Analysis

IAMDV — Fri, 06 May 2011 14:18:02 GMT

Finally, I got it working with trail & error method.... My logic was right but my syntax was incorrect.

Here is what I need

COUNT

({$<TimeStampValue={$(=($(vPreviousHour)))},

Q_No = {'Q1'},

Label_Text = {1} Label_Text,

Resp_ID = p({$<TimeStampValue={$(=($(vMaxCurrentTime)))}>} Resp_ID)>}

Resp_ID)

Many thanks to those who read this post!

Cheers - DV

topic Re: Filter data based on selected fields in Set Analysis in QlikView

*** Filter data based on selected fields in Set Analysis / Using Indirect Analysis ***

Re: Filter data based on selected fields in Set Analysis

Re: Filter data based on selected fields in Set Analysis

Re: Filter data based on selected fields in Set Analysis

Re: Filter data based on selected fields in Set Analysis

* Filter data based on selected fields in Set Analysis / Using Indirect Analysis *