topic Is it possible Multiple Set Analysis in one Expression? in QlikView

Is it possible Multiple Set Analysis in one Expression?

Mon, 10 Oct 2011 10:51:47 GMT

Hi All,

I have to apply conditions on 2 fields like Status(Complete or In Progress) and Year (2000 - till date, with some null values).

I need to show/display the records in Straight Table / Pivot Table which meets the condition given below

1. Status = In Progress ( here no year filter )

2. Status = Complete ( based on the year selection done by the end user )

Any function is ok like nested if or set analysis.

The other selection fields like Dept, Product, etc.. should make the impact on this table against selection.

All kind of suggestions are welcome....Thanks

Thanks

Gangadharan M

Is it possible Multiple Set Analysis in one Expression?

kaushiknsolanki — Mon, 10 Oct 2011 10:58:16 GMT

Hi,

Considering you have a projectid, Year and status.

Create a straight table with dimension as projectid,status with expression as

sum({<Projectid = p({1<status = {"In Progress"}>}Projectid),Status = {"Complete"} >}1)

Let me explain how it will work.

It will give you project id where the status is in progress without considering the filter where as project id when status is complete based on selection.

Try it and let me know.

Regards,

Kaushik Solanki

Is it possible Multiple Set Analysis in one Expression?

Tue, 11 Oct 2011 10:44:54 GMT

Almost correct only there is small difference in displaying records. I am checking this.

Thanks a lot for your valueable time & great idea....