Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Qlik noob - tried searching but perhaps not aware of what lingo to use just yet.
I have a table and I would like to filter it according to 1 specific field, without using Selections / Filter Pane (i.e. a constant parameter). I also don't want to add the parameter field to the table.
So say I have dozens of fields. I have a field called [QRT] but I do not add this to the table. I would like the table to only display records where [QRT] = 'S0602'.
Can someone offer me a steer please?
Thanks
Jon
Hi Jon,
You'd have to use set analysis for that.
As an example, say you want the sum of sales for the QRT field equal to S0602, you would need to do the following:
sum({<QRT={'S0602'}>}Sales)
The bolded part {<QRT={'S0602'}>} would be the "filter" based on some criteria you want, even though you didn't select anything and the field is not on your table.
Felipe.
Hi Felipe
Thank you for your suggestion. However in this case I do not want to aggregate any numeric results. Mine is a table of text values and I want to limit records according to a criterion. QRT is a field (not in table) and I want to only show records that are associated where [QRT] = 'S0602'.
Thanks
Jon