Unable to display 'Yes', 'No', 'Missed' condition in Pivot table

[#1]

Hi,

I am trying to create Pivot table with simple 'Yes', 'No', 'Missed'  options according to datetime stamp condition.

Something like below:

Code	FormName	Initial	Visit1	Visit2	Visit3	Visit4	Visit5
1111	AA	Y	-	Y	Y	-	Y
1111	BB	-	Y	Y	Y	-	Y
2222	AA	Y	Y	Y	Y	-	Y
2222	BB	Y	Y	Y	Y	-	Y
3333	AA	Y	Y	Y	Y	Y	Y
3333	BB	Y	Y	Y	Y	Y	Y

I have only 2 static forms 'AA' and 'BB' and the condition is based on FormSave time....If FormSave Time is there then shoe 'Yes' if timestamp shows 'No'...if both forms timestamp is not there show 'Missed'.

I tried number of ways like loding inline table and then joining to the main table with form name...but it only shows those have formsave time.

Does someone have any idea to resolve this issue? Help appreciated.

Thanks,

Mak

[vishsaggi]

Quite did not get you, where is the field FromSaveTime in your above table. Can you explain little more here ?

[#3]

Thanks Vishwarath for your replt.

Say..I have a 2 tables

Table A
Code	InitialActivation Time	Visit1ActivationTime	Visit2ActivationTime	Visit3ActivationTime	Visit4ActivationTime	Visit5ActivationTime
1111	13/02/2017	18/02/2017	20/02/2017	-	-	25/02/2017

And

Table B
Code	FormType	FormSaveTime	VisitName
1111	AA	13/02/2017	Initial
1111	BB	13/02/2017	Initial
1111	AA	18/02/2017	Visit1
1111	AA	20/02/2017	Visit2
1111	BB	20/02/2017	Visit2

And I want to achive something like

But it shows only data which is present ...ex: Visit1 BB form is not displayed..

I want to show missed also.

Thanks,

[vishsaggi]

Can you share this sample data and expected output you want please?

[#5]

Hi,

I think I shared whatever I have to replicate for this scenario.

Please do let me know If you or anyone genuinely know how to handle left (inline join) and display Yes/no/Missing options in Qliksense Pivot table?

Honestly, I am loosing level of confidence on QlikSense ...as no expert from QlikTech or anyone know how to handle left join (like SQL) and show conditional yes or no or missing IF condition in QlikSense ...which is bit easy in any other visualization tool or any SQL LEFT JOIN.

If anyone does still know any workaround please help me.

Thanks,

Mak

[vishsaggi]

This is QV dev forum, did you post this in Qlik Sense Forum? over here:

Qlik Sense Forums