Exporting with filter

[Anonymous]

Hello everybody, hope you are fine

I am using Qlick sense Desktop , In Qlik is there a possibility to see the filtered data on the graph? I mean when you are filtering there is a bar on the top shows the filtered items and bellow the information or the graph are shown according  to the filters, once you want to export the the graph nobody knows what the graph is about , I want to show the filtered infrmartion in a label  show in the graph while exporting the graph in the PDF, you can see the pictues to better underestand. Thanks

[YoussefBelloum]

My bad, It was the match() function, it should be replaced by the WildMatch() function, like this:

=pick(wildmatch(GetCurrentSelections(),'*Field1*'),'abbreviation1')&' '&pick(wildmatch(GetCurrentSelections(),'*Field2*'),'abbreviation2')&' '&pick(wildmatch(GetCurrentSelections(),'*FieldN*'),'abbreviationN')

you can add as much pick(wildmatch... with this &' '& as you want

[Anonymous]

dude, Thank you so much, it worked! but i am trying to go deeper , it is becoming challenging for me ,
so now , what if the Prouction field contains some code, and if i choose one of the codes of a product ,
i want to show "Prod : PRODUCT CODE HERE",
any idea?

[YoussefBelloum]

Before going further, I should know what is your exact field format or values ?

[YoussefBelloum]

Actually it is easier than I thought:

=pick(wildmatch(GetCurrentSelections(),'*Field1*'),'abbreviation1'&' '&GetFieldSelections(Field1))&' '&pick(wildmatch(GetCurrentSelections(),'*Field2*'),'abbreviation2'&' '&GetFieldSelections(Field2))&' '&pick(wildmatch(GetCurrentSelections(),'*FieldN*'),'abbreviationN'&' '&GetFieldSelections(FieldN))

[Anonymous]

you answered yourself

[Anonymous]

Thank you so so so much buddy , now i got what i was looking for

[YoussefBelloum]

You're welcome, good luck

[Anonymous]

hello buddy , again me   i have a problem here, if i choose more than 7 product or item of the same type or same filter , it is automatically minimized, like in the photo! how can i solve this problem ? also another optional problem, how can i show different filters with different color when i am showing them in the title, for example filter YEAR with yellow and filter PRODUCT with red and so on...

[MartinQL]

Hi guys, this seems not to work when you want to export to Excel the data of a table. Is there any solution to see the filtered panes when exporting data to an Excel file?

Thanks!

[erltrth2018]

Did you get any answer to your question?