Discussion Board for collaboration related to QlikView App Development.
Dear Qlik Viewers,
I am getting hyphen in my graph as you can see in the last right hand.
I am unable to rectify this issue, please assist.
Below is the table view of the 3 files which I am using for qlik view document but it has created 01 Syn Key.
Appreciate your assistance.
I have checked the data once again, but in my data all the dates have values and nothing as null.
First try to remove synthetic keys like this:
STAFFNO &'|'&CRank as %Key,
STAFFNO as Active_STAFFNO ,
CRank as Active_CRank ,
....rest of the fields;
STAFFNO as Indicator_STAFFNO ,
CRank as Indicator_CRank ,
STAFFNO as Assesment_STAFFNO ,
CRank as Assesment,
Else if you want to use a single Field in UI then you have to compliment Link tables.
You can find the link table logic here:
You can also comment STAFFNO and CRank from two tables if you know which table is the master table which have all possible entries.