Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In a filter, I have a field with this expression: ={<previous_year_comparison = 1>} event_name
Then I have a line chart with an expression that I want the other field not to be taken into account.
This is the expression: Sum({< year_event=,event_name=, month_event=, event_code = p(previous_event_code)>} quantity )
I need to add the first expression somehow like this: Sum({< INSERT HERE EXPRESSION =, year_event=,event_name=, ....
How could I do it? Many thanks.
@sersal10 The requirement is unclear, by reading context you maybe assuming to keep here.
Sum({< previous_year_comparison = {1}, year_event=,event_name=, month_event=, event_code = p(previous_event_code)>} quantity )
Hi Anil,
That didn't work. There may not be a possibility to do this in Qlik. Hence I created a new column in my database with this code:
@sersal10 If it is in Qlik, the same way you can written like.
If(previous_year_comparison = 1, Sum({<year_event=,event_name=, month_event=, event_code = p(previous_event_code)>} quantity ), Null())