Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lavanya14
Contributor III
Contributor III

Applying possible selections of a field to another field

Hi All,

I have a timestamp field1 (format 26/07/2018 01,26/07/2018 02 etc) also I have got another field2. I need to apply the selected values (lets say if 10 values are selected ) of field1 to field2 in set analysis.Filed1 and field 2 are from different tables joined with date.

Any suggestions are appreciated.

Thanks in advance.

14 Replies
YoussefBelloum
Champion
Champion

Hi,

here is a set analysis example you can try to apply

{<Field2={"$(=Concat(distinct Field1))"}>}


PS: make sure that both fields are on the same timestamp format

Anil_Babu_Samineni

Not really sure, If i understand correctly, But perhaps this?

Sum({<Date1 = {"=Date1 = Date2"}>} Sales)

Or

Sum(If(Date1=Date2, Sales))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

May be this

{<Field2 = p(Field1)>}

balabhaskarqlik

May be this:

=num(avg({1<Field1={'$(=getfieldselections(Field2))'}>} Sales),'0.00')

=Sum({1<Field1={'$(=getfieldselections(Field2))'}>} Sales).

Anonymous
Not applicable

Lavanya,

Can you provide sample data\App?

lavanya14
Contributor III
Contributor III
Author

Hi All,

Many thanks for your reply. I am still working on this. Will update you all soon.

Thanks again.

lavanya14
Contributor III
Contributor III
Author

Hi All,

Can some one suggest me how to select set of field values of Field 1(timestamp) in Field2.(day)

Let's say I have the timestampvalue (dd/mm/yyyy hh) in Field1 and if the values selected in Field1 are 29/07/2018 00 to 31/07/2018 09. so I need to select the days in field 2 which are 29,30 and 31. Field1 and field2 are in different tables. I would like to make this selection in via button trigger.

Any suggestions are much appreciated.

Thanks in advance.

Anil_Babu_Samineni

Not really sure - What your request. Would you like to share work file which is faster than slower response ..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
lavanya14
Contributor III
Contributor III
Author

Hi Anil,

Thanks for replying. Please find the sample data attached.