Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Exporting with filter

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

image001.pngimage002.png

20 Replies
Highlighted
Champion
Champion

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

Highlighted
Creator
Creator

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?

Highlighted
Champion
Champion

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

Highlighted
Champion
Champion

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))

Highlighted
Creator
Creator

you answered yourself

Highlighted
Creator
Creator

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

Highlighted
Champion
Champion

You're welcome, good luck

Highlighted
Creator
Creator

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...2018-04-30_10h53_22.jpg
2018-04-30_10h50_34.jpg

Highlighted
Contributor II
Contributor II

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!

Highlighted
Contributor II
Contributor II

Did you get any answer to your question?