topic Problem regarding Set Analysis in QlikView

Problem regarding Set Analysis

Mon, 24 Oct 2011 09:56:40 GMT

Dear All,

Can any one please help me in regarding set analysis.

I am having a expression using if Condition as:

If(Date_Master>=Min_Date and Date_Master<=Max_Date,Sales)

I want to make this expression using Set Analysis.

Please Help me to write a expression using Set Analysis.

Waiting for reply,

Regards,

Pranav

lironbaram — Mon, 24 Oct 2011 09:59:23 GMT

sum({<Date_Master={">=$(#Min_Date) <=$(#Max_Date)"}>}Sales)

Mon, 24 Oct 2011 10:03:33 GMT

Dear baram,

Thanks for your reply, but the expression send by you doesnt work properly it shows all the value in 0.

Please Check and give a correct answer.

Regards,

Pranav

jagannalla — Mon, 24 Oct 2011 10:36:16 GMT

=(Sum({$<Date_Master={">$(Min_Date)<=$(Max_Date)"}>} Sales))

Try this it may helps you...

jagannalla — Mon, 24 Oct 2011 14:17:01 GMT

Pranav,

Do you got the solution?