Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

udaya_kumar
Valued Contributor

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

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?

Tags (2)
2 Replies
MVP
MVP

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

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
Valued Contributor

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

thanks for the information,

i will try it out...