Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Uri
Contributor III
Contributor III

SET analysis expression into a Variable

Hi,

My idea is to create a variable that I will use in NPrinting after.

date(date#(max({<FIELD1={'XXXXXXXXXX'}, FIELD2={'xxxxxxxxxxx'}>}total FIELD3),'YYYY-MM-DD'),'YYYYMM')

I tried this way but it didnt work.

LET vNPrinting =  '=date(date#(max({<FIELD1={'XXXXXXXXXX'}, FIELD2={'xxxxxxxxxxx'}>}total FIELD3),'YYYY-MM-DD'),'YYYYMM')'

Can anyone help?

Labels (3)
3 Replies
Chanty4u
Champion III
Champion III

is this working ?  without variable?

date(date#(max({<FIELD1={'XXXXXXXXXX'}, FIELD2={'xxxxxxxxxxx'}>}total FIELD3),'YYYY-MM-DD'),'YYYYMM')  

 

 

Uri
Contributor III
Contributor III
Author

Hi @Chanty4u ,

Yes, it works if I apply this in my table.

BR,

Artur

Uri
Contributor III
Contributor III
Author

Any ideas on this? 🙂