topic Re: Set Anaylsis Question in QlikView

Set Anaylsis Question

Tue, 28 Jun 2011 18:17:48 GMT

In the attached document in the tab "Service Ticket" I have a chart object titled "Service Ticket Records" and trying to determine what the correct Set Analysis to bring back all dates where "Status =2".

Set Anaylsis Question

nagaiank — Tue, 28 Jun 2011 18:56:34 GMT

If you select the status of 2 in the multibox, the table below shows all the records of interest. Is there anything else needed?

Set Anaylsis Question

Tue, 28 Jun 2011 19:03:38 GMT

I am trying to have the chart object "Service Ticket Records" default to status 2 versus changing the status list box as users want to switch from tabs without the status alternating from different status.

Re: Set Anaylsis Question

johnw — Tue, 28 Jun 2011 19:16:51 GMT

It appears that all of your expressions can be dimensions instead. Do that. Then add new expression:

only({<Status*={'2'}>} Date)

On the presentation tab, hide that column. Now, the way I set it up, it won't OVERRIDE the selected status. So if someone selects status 1, nothing will display in the chart because status 2 has been excluded. If you STILL want to display all the status 2 data in the chart, even when it isn't a possible value, then just remove the *.

Set Anaylsis Question

Tue, 28 Jun 2011 19:42:58 GMT

John,
I got that working, is there a way when you select the service ticket tab it shows all of the status 2 in the chart versus having to change the status list box to 2 in order for the rows to return in the chart.

Set Anaylsis Question

johnw — Tue, 28 Jun 2011 19:46:59 GMT

I don't understand. The set analysis IS how you show all status 2 in the chart without having to change the status list box to 2, with or without the * depending on the exact requirement. In your example, I think you've selected a date for which there is no status 2, so there is nothing to display. Is that the problem? Sorry, I guess I'm not not following.

Set Anaylsis Question

Tue, 28 Jun 2011 19:49:28 GMT

Sorry for the confusion. When selecting the service ticket tab I am trying to get the chart to populate with all dates that have a status "2" without have to change the list boxes for status and all dates so the other tabs point of view don't change.

Re: Set Anaylsis Question

johnw — Tue, 28 Jun 2011 19:52:17 GMT

OK, so if someone selects status 1 or a specific date, you want to completely ignore that? I guess you might want to ignore ALL selections?

only({1<Status={'2'}>} Date)