i want to get two values from if condition in qlikview 10

[udaya_kumar]

hi,

My scenario is that, i am applying 'time frame' filter to the straight table, so the values for time frame is like '3months vs 3months' or '6months vs 6months'. so i need to apply this to the table, i was trying like assigning monthid=3, if we select 3months vs 3months and monthid=6, if we select 6months vs 6months.

And the data in the table is 'Volume'.

so the if condition look like

=Sum(if(prod='Humira',Vol))

but i want to assign even filter value with this if condition like

=Sum(if(prod='Humira',Vol,if(Time_Monthly='3Months Vs 3Months')))

but this is not working

so how i can get two values in if condition. Vol and monthid=3 or 6 based on filter value?

[swuehl]

Not sure if I completely understand, but you could use logical operators like and / or to combine conditions, maybe like

=Sum(if(prod='Humira' and Time_Monthly='3Months Vs 3Months',Vol))

[udaya_kumar]

thanks for the information,

i will try it out...